Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need the answers in formulas please 1. Complete the capital budgeting methods 3 FILE HOME INSERT DAGE LAYOUT Comparison of Capital Budgeting Methods -
i need the answers in formulas please
1. Complete the capital budgeting methods 3 FILE HOME INSERT DAGE LAYOUT Comparison of Capital Budgeting Methods - Excel REVIEW Vw FORMLILAS DATA X Accounting Auto Er wrap Test Merge & Center S.9. HH Insert Deute Format bor Conditional Format Cell Formatting Table Styles Sty Chew A Nu 821 c 5 1,750,000 3 years 225,000 5 A 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment Project life 4 Salvage value 5 6 The project would provide net operating income each year as follows 7 Sales 5 Variable expenses Contribution mare 10 depenses 11 Salares, rent and other fred out of pocket costs Depreciation 13 Total fed expenses 16 Net operating income 15 10 cost of Capital 2.750.000 1.000.000 1,150.000 $ 520,000 159.00 200.00 AN 11. Compute the annual net cash flow from the project 19 3. 10. Complete the following line to compute the net rent value of the future cash flow for the project Don't forget to include the sale in years 21 13 Year FILE HOME INSERT Comparson of Capital Budgeting MethodExcel REVIEW VW PAGE LAYOUT FORMULAS DATA Accounting BU -A A Wrap Text Merge Center Agent $.96 Conditional Formatas Call Formatting Table Styles Insert Delete Format Ces Clear B23 c . Year 12 10 2. Complete the following timeline to compute the net present value of the future cash nown for this project. Don't forget to include the salvage value in years 11 O 1 2 Net cash flow 14 Discount Factor = 1/(1.4) 1.000 15 present value of the cash flows 16 Net present value 13 18. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero 19 NOV of Cash Flows from Years 1.5 10 the cost of the investment 31 Net present value 12. Write an it/then statement to ACCEPT OF REJECT the project based on NPV 144. Use Excel's IR function to compute the project's internal rate of return 15 Write ant/then statement to ACCEPT OF RECT the project based on IRR 17 5. Compute the projects payback period Years o compute the project's accounting rate of return 16 18 SO Shes 1. Complete the capital budgeting methods 3 FILE HOME INSERT DAGE LAYOUT Comparison of Capital Budgeting Methods - Excel REVIEW Vw FORMLILAS DATA X Accounting Auto Er wrap Test Merge & Center S.9. HH Insert Deute Format bor Conditional Format Cell Formatting Table Styles Sty Chew A Nu 821 c 5 1,750,000 3 years 225,000 5 A 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment Project life 4 Salvage value 5 6 The project would provide net operating income each year as follows 7 Sales 5 Variable expenses Contribution mare 10 depenses 11 Salares, rent and other fred out of pocket costs Depreciation 13 Total fed expenses 16 Net operating income 15 10 cost of Capital 2.750.000 1.000.000 1,150.000 $ 520,000 159.00 200.00 AN 11. Compute the annual net cash flow from the project 19 3. 10. Complete the following line to compute the net rent value of the future cash flow for the project Don't forget to include the sale in years 21 13 Year FILE HOME INSERT Comparson of Capital Budgeting MethodExcel REVIEW VW PAGE LAYOUT FORMULAS DATA Accounting BU -A A Wrap Text Merge Center Agent $.96 Conditional Formatas Call Formatting Table Styles Insert Delete Format Ces Clear B23 c . Year 12 10 2. Complete the following timeline to compute the net present value of the future cash nown for this project. Don't forget to include the salvage value in years 11 O 1 2 Net cash flow 14 Discount Factor = 1/(1.4) 1.000 15 present value of the cash flows 16 Net present value 13 18. Use Excel's NPV function to compute the present value of the cash flows from years 1-5. Do not include the original investment at time zero 19 NOV of Cash Flows from Years 1.5 10 the cost of the investment 31 Net present value 12. Write an it/then statement to ACCEPT OF REJECT the project based on NPV 144. Use Excel's IR function to compute the project's internal rate of return 15 Write ant/then statement to ACCEPT OF RECT the project based on IRR 17 5. Compute the projects payback period Years o compute the project's accounting rate of return 16 18 SO Shes Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started