60.1K

Verified Solution

Link Copied!

Create your own business and numbers for this question. Please show formulas in excel for the first part, and then write the memo as well. I know this is quite a bit of work so I am willing to venmo whoever answers this question. Thank you!

EXCEL ANALYSIS

Students should, at a minimum, consider the following when working in Excel:

Initial cash flows, operating cash flows, and terminal cash flow. Organize your data similar to the case at the end of chapter 12 of the textbook.

Compute Payback; IRR; NPV; NPV profile.

Conduct a Sensitivity/Scenario analysis.

Demonstrate an understanding of how the project will be financed. Understand that debt and interest expenses are generally not included in the analysis (see the text for an explanation why).

Your results should be presented graphically as well. A minimum of the NPV profile should be presented.

The analysis required is similar to the case at the end of Chapter 12, except you need to develop the project yourself.

The assignment is a two-page memorandum plus appendices that summarize and report the results of the capital budgeting project conducted.

WRITTEN MEMO

The memorandum should contain the following four sections:

Contain an introduction.

Provide any necessary explanations and background to understand the project.

Summarize the results that are included in the appendix (Excel Worksheet). The writer should reference key financial concepts in the memo including:

Initial cash flows, operating cash flows, and terminal cash flow

Payback; IRR; NPV; NPV profile

Sensitivity/Scenario analysis

Financing

Provide some type of concluding comments.

The actual computations and or explanation of the computations should be in the attached Excel spreadsheet.

The memorandum should be written assuming that the reader understands the material in this course. When you write, you will share the specific details and results associated with the project; you should not be explaining financial concepts.

Everything you turn in will be either in Microsoft Word or Excel. Two page maximum (single-spaced) applies to the memorandum (the excel files can contain many pages, but should be organized and clearly formatted). See late paper policy in the syllabus, turning the paper in late can have significant consequences. The memo should be properly formatted and cut and paste into a post. The Excel spreadsheet should be an attachment.

Answer & Explanation Solved by verified expert

See Answer