Question: You will create your analysis using 5 worksheets contained in a single Excel spreadsheet.You must include documentation as specified below.You must parameterize each variable(e.g., define

You will create your analysis using 5 worksheets contained in a single Excel spreadsheet.You must include documentation as specified below.You must parameterize each variable(e.g., define and document each variable outside of a formula)for easy "what if" analysis and also for readability of your spreadsheet.Remember, other people will be reading this spreadsheet! 1. Cover Page: Use a textbox to specify the title of your report, your name and the date. 2. Executive Summary: Summarize the purpose of the analysis, the content of your worksheets, and your final recommendation for the CEO.3.Cost-benefit Analysis: This sheet should include: an appropriate title for this analysis and, on the second line, type "BUS311,,". The title should be centered and large. the cost-benefit analysis format is similar to but not exactly the same as the one in FIGURE 9.5(on digital page 356) of the course textbook. you should include the interest cost for each year in your calculation.(Hint: your monthly payment is not your cost). you must include a break-even analysis chart. In your spreadsheet, you should indicate which year is the breakeven year, and print "Breakeven year" below that cell only. you should provide a conclusion regarding your proposal based on the cost-benefit analysis (included in the Executive Summary). documentation (see below)4. Loan: the calculation of the monthly payment for the loan an amortization table including theyearly interest costfor the loan.You can use Excel's PMT function for this purpose.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!