Answered step by step
Verified Expert Solution
Link Copied!

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 -

image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Forest Management Auditing

Authors: Lucio Brotto

1st Edition

0367605872, 978-0367605872

More Books

Students also viewed these Accounting questions

Question

True or false scripting languages are programming languages to

Answered: 1 week ago