Capital Recovery Ch 5 HW-F23 (1)

xlsx

School

University of Michigan *

*We aren’t endorsed by this school

Course

591

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

11

Uploaded by BrigadierDuck1962

Report
Problem 5-45 Estimated Annual Return: 8% Type of Analysis: Yearly Net Return Rate in Calculation: 8.000% INITIAL CASH OUTLAY $ 450,000 Year Cash Flow Rolling NPV 0 $ (450,000) 1 $ (42,500) $ (489,352) 2 $ 92,800 $ (409,791) 3 $ 386,000 $ (103,372) 4 $ 614,600 $ 348,378 5 $ (202,200) $ 210,764 NPV $ 210,764 IRR 21.40% Brad's Tip of the Day Even though it was give with a guess of 8% whe from years of calculatin Change to 10% to see th Note that, using Excel logic, I ha this NPV/IRR table convertible t types (i.e. Monthly, Weekly, Dai Calculation automatically chang you change the Type of Analysis you pick from a drop-down list).
en in the problem, I usually start en figuring IRR…..this is an old habit ng it manually. he NPV change ave made to other ily). ge when s (which .
Problem 5-47 Problem 5-47 (Alternative Approach Estimated Annual Return: 8% Estimated Annual Return: Type of Analysis: Yearly Type of Analysis: Net Return Rate in Calculation: 8.000% Net Return Rate in Calculation: Start the project in Year 4 timeframe: Old Year 1 ($500K) becomes: Old Year 2 ($300K) becomes: Old Year 3 ($100K) becomes: INITIAL CASH OUTLAY $ - INITIAL CASH OUTLAY Year Cash Flow Rolling NPV Year Cash Flow 0 $ - 0 $ (1,312,224) 1 $ 500,000 $ 462,963 1 $ 150,000 2 $ 300,000 $ 720,165 2 $ 200,000 3 $ 100,000 $ 799,548 3 $ 250,000 4 $ (2,400,000) $ (964,524) 4 $ 300,000 5 $ 150,000 $ (862,436) 5 $ 350,000 6 $ 200,000 $ (736,402) 6 $ 400,000 7 $ 250,000 $ (590,530) 8 $ 300,000 $ (428,449) NPV $ (92,628) 9 $ 350,000 $ (253,362) IRR 5.97% 10 $ 400,000 $ (68,085) Better but still a losing effort NPV $ (68,085) IRR 4.09%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
h) Problem 5-47 (Where you need to be 8% Estimated Annual Return: Yearly Type of Analysis: 8.000% Net Return Rate in Calculation: 8% Investment rate Start the project in Year 4 timeframe: $ 629,856 Old Year 1 ($500K) becomes: $ 349,920 Old Year 2 ($300K) becomes: $ 108,000 Old Year 3 ($100K) becomes: $ 2,400,000 Project INITIAL CASH OUTLAY $ 1,087,776 Value of first 3 years at the start of Year 4 $ 1,312,224 Rolling NPV Year Cash Flow 0 $ (1,219,596) $ (1,173,335) 1 $ 150,000 $ (1,001,867) 2 $ 200,000 $ (803,409) 3 $ 250,000 $ (582,900) 4 $ 300,000 $ (344,696) 5 $ 350,000 $ (92,628) 6 $ 400,000 NPV $ 0 IRR 8.00% You need to get a 11.6077% return on
e) 8% Yearly 8.000% 11.6077% Investment rate $ 695,108 $ 373,688 $ 111,608 $ 2,400,000 Project $ 1,180,404 Value of first 3 years at the start of Year 4 $ 1,219,596 Rolling NPV $ (1,080,707) $ (909,239) $ (710,781) $ (490,272) $ (252,068) $ 0 n your pre-project cash flows to make this work.
Problem 7-9 Estimated Annual Return: 8% Type of Analysis: Yearly Net Return Rate in Calculation: 8.000% INITIAL CASH OUTLAY $ 4,900.00 Year Cash Flow Rolling NPV Payback Method 0 $ (4,900) Number of whole years: 1 $ 1,875 $ (3,164) Partial year value: $ 1,150 2 $ 1,875 $ (1,556) Partial year quotient: 3 $ 1,875 $ (68) 4 $ 1,875 $ 1,310 Payback (years): 5 $ 1,875 $ 2,586 NPV $ 2,586 IRR 26.41%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 0.235 2.235
Problem 5-54 Estimated Annual Return: 8% Type of Analysis: Yearly Net Return Rate in Calculation: 8.000% INITIAL CASH OUTLAY $ 275,000.00 Year Cash Flow Rolling NPV 0 $ (275,000) 1 $ (35,000) $ (307,407) 2 $ 55,000 $ (260,254) 3 $ 175,000 $ (121,333) 4 $ 250,000 $ 62,424 The Project meets the benchmark 5 $ 350,000 $ 300,628 6 $ 100,000 $ 363,645 7 $ 100,000 $ 421,994 8 $ 100,000 $ 476,021 9 $ 100,000 $ 526,046 10 $ 100,000 $ 572,366 NPV $ 847,366 IRR 267.98%
Estimated Annual Return: 8% Type of Analysis: Yearly Net Return Rate in Calculation: 8.000% INITIAL CASH OUTLAY $ 275,000.00 Year Cash Flow Rolling NPV 0 $ (275,000) 1 $ (35,000) $ (307,407) 2 $ 55,000 $ (260,254) 3 $ 175,000 $ (121,333) 4 $ 250,000 $ 62,424 NPV $ (131,550) IRR 4.04% Just for good measure, the IRR is 4.04% at Not over the hurdle rate, but on the right tra
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 years ack
Daily Weekly Monthly Quarterly Yearly