{"id":61482,"date":"2022-05-16T03:18:05","date_gmt":"2022-05-16T03:18:05","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/finance-excel-project-business-finance-homework-help\/"},"modified":"2022-05-16T03:18:05","modified_gmt":"2022-05-16T03:18:05","slug":"finance-excel-project-business-finance-homework-help","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/finance-excel-project-business-finance-homework-help\/","title":{"rendered":"Finance excel project | Business &#038; Finance homework help"},"content":{"rendered":"<div>\n<p>For this project, please use Excel to do your calculations and analysis and then type a report in MS Word. Your report should clearly and thoroughly answer the eight questions below. The report should be typed double-spaced using a Times New Roman Font, size 12. Please limit your report to no more than 10 pages. Submit your report and Excel file on Blackboard, as well as provide me a hard copy of your report in class. All of this needs to be completed by the listed due date on the syllabus.<strong>You must use scenario manager function from EXCEL for this Project.<\/strong> <\/p>\n<p>1) \u00a0Use the base case assumptions (pg. 4) as well as the information presented in the case to build a four-year discounted cash flow model for Advanced Seal given a 50% cannibalization rate for the Premium Product and a 15% cannibalization rate for the Basic Product. What are your NPV and IRR results? Please use the \u201cBasic Template\u201d from the excel file provided for the project.<\/p>\n<p>2) Calculate (1) again using a 55% cannibalization for the Premium Product and a 15% cannibalization rate for the Basic Product. Show your NPV and IRR results.<\/p>\n<p>3) Calculate (1) again using a 60% cannibalization rate for the Premium Product and a 15% cannibalization rate for the Basic Product. Show your NPV and IRR results.<\/p>\n<p>4) Use the model developed in (1) to test the implications of Christina Whitman\u2019s \u201cProposal to Drive Revenue&#8221; (pg. 5). Please use a 50% cannibalization rate for the Premium Product and a 15% cannibalization rate for the Basic Product. Show your NPV and IRR results. Now, repeat this step but use<\/p>\n<ul>\n<li>a 57.5% cannibalization rate for the Premium Product and a 15% cannibalization rate for the Basic Product. Show your NPV and IRR results.<\/li>\n<li>a 65% cannibalization rate for the Premium Product and a 15% cannibalization rate for the Basic Product. Show your NPV and IRR results.<\/li>\n<\/ul>\n<p>5) Use the model developed in (1) to test the implications of Margaret Tan\u2019s \u201cProposal to Minimize Cannibalization\u201d (i.e. raising the price to $23 dollar and minimize the cannibalization rate to 45% &#8211; pg.6) Show your NPV and IRR results.<\/p>\n<p>6) Summarize your results for part (1) to (5) using the \u201csummary of scenarios \u201ctemplate provided in the excel file. Also, please recommend what P&amp;G should do (between Proposal to Drive Revenue\u00a0 &amp; Proposal to Minimize Cannibalization )<\/p>\n<p><strong>Hint:<\/strong><\/p>\n<ol>\n<li>Cannibalization of 50% = &#8211; 50% * 2,000,000 = -1,000,000 \u00e0 reduce 1 million Premium Product, same principles apply for Basic Product.<\/li>\n<li>You can set Net Working Capital Turnover to run at a rate of 9 (average of 8 to 10 times).\u00a0\u00a0 Footnote 4: Net Working Capital = Incremental Revenue\/ Net Working Capital Turnover.<\/li>\n<li>The depreciation expense is based on the depreciation schedule in Footnote 3.<\/li>\n<li>The Terminal Value for the capital expenditure is calculated as the tax shield of the remaining book value times the tax rate.<\/li>\n<\/ol>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>For this project, please use Excel to do your calculations and analysis and then type a report in MS Word. Your report should clearly and thoroughly answer the eight questions below. The report should be typed double-spaced using a Times New Roman Font, size 12. Please limit your report to no more than 10 pages. [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-61482","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/61482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=61482"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/61482\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=61482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=61482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=61482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}