Capital Budgeting Excel Assignment, Assignments of Management Accounting

Download Capital Budgeting Excel Assignment and more Assignments Management Accounting in PDF only on Docsity!

INSTRUCTIONS

Download the Excel Assignment spreadsheet and save it. Enter your first name and last name in cell A1 on the Excel Assignment worksheet. DO NOT ALTER THE FORMATTING OF ANY OF THE SHADED AREAS OR SHADED CELLS in the Excel Assignment works The data from the assignment is provided in rows 3 - 14. Do not alter these cells. Use only cell references in making your calculations. Do not manually re-enter any of the data already provided. Do not use PV tables or financial calculators. Make all your calculations on the Excel worksheet, including Excel fun Use cell references, Excel calculations, or Excel functions to show the results in the yellow-shaded cells. Manually e answers in the yellow cells will result in a zero score for that answer. After you complete your assignment, save your work. Submit your assignment by uploading your Excel worksheet file on Canvas by the due date.

Investment $ (500,000) NPV $ 42,564 PV(cash inflows) > PV (cash outflows) c. Using Excel Function for IRR (=irr) IRR 16.27% higher than cost of capital of 13% d. Decision Accepted

 - Year 

• Year
• $ 145,
• $ 60,
• $ 145,
• $ 205,