Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show work in excel Problem 3 10 Points A cash flow chart for a project at BillCo is shown below. Years Initial Cost Salvage

image text in transcribed

please show work in excel

Problem 3 10 Points A cash flow chart for a project at BillCo is shown below. Years Initial Cost Salvage Op Costs Benefits Net Cash Flow 0 $ (513,295.00) $ (513,295.00) 1 $ (79,999.64) $181,992.72 $ 101,993.08 2 $ (82,609.63) $189,818.41 $ 107,208.78 3 $ (85,295.31) $ 197,980.60 $ 112,685.29 4 $ (88,058.87) $206,493.76 $ 118,434.89 5 $ (90,902.58) $215,373.00 $ 124,470.42 6 $ (93,828.75) $ 224,634.03 $ 130,805.28 7 $ (96,839.79) $234,293.30 $ 137,453.51 8 $73,240.00 $ (99,938.14) $ 244,367.91 $ 217,669.77 UT 00 Use a MARR of 12% 3a. Determine the NPW 3b. Determine the AW 3c. Determine the FW 3d. Deterine the IRR 3f. Graph the NPW versus MARR 36. Are we making or losing money at 12% MARR? How can you tell? Problem 3 10 Points A cash flow chart for a project at BillCo is shown below. Years Initial Cost Salvage Op Costs Benefits Net Cash Flow 0 $ (513,295.00) $ (513,295.00) 1 $ (79,999.64) $181,992.72 $ 101,993.08 2 $ (82,609.63) $189,818.41 $ 107,208.78 3 $ (85,295.31) $ 197,980.60 $ 112,685.29 4 $ (88,058.87) $206,493.76 $ 118,434.89 5 $ (90,902.58) $215,373.00 $ 124,470.42 6 $ (93,828.75) $ 224,634.03 $ 130,805.28 7 $ (96,839.79) $234,293.30 $ 137,453.51 8 $73,240.00 $ (99,938.14) $ 244,367.91 $ 217,669.77 UT 00 Use a MARR of 12% 3a. Determine the NPW 3b. Determine the AW 3c. Determine the FW 3d. Deterine the IRR 3f. Graph the NPW versus MARR 36. Are we making or losing money at 12% MARR? How can you tell

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

Analysis For Financial Management

Authors: Robert Higgins, Jennifer Koski, Todd Mitton

13th Edition

1260772365, 978-1260772364

More Books

Students also viewed these Finance questions