Question
Suppose you have annual cash flows per the attached Microsoft Excel file: HCA415Quiz5.xlsx Calculate the cumulative cash flows for years 0-9. Format cumulative cash flows
-
Suppose you have annual cash flows per the attached Microsoft Excel file: HCA415Quiz5.xlsx Calculate the cumulative cash flows for years 0-9. Format cumulative cash flows with dollar signs and commas to separate thousands. Do not place spaces before/after dollar signs and commas. For negative cash flow values, use parenthesis just like in year 0, ($25,000,000).
Year
Annual Cash Flows
Cumulative Cash Flows
0
($25,000,000)
1
$1,500,000
2
$1,750,000
3
$3,500,000
4
$4,750,000
5
$3,750,000
6
$4,750,000
7
$6,250,000
8
$5,750,000
Calculate Payback, which is the point at which a project's initial costs are fully recovered =
Assume that cash flows are evenly distributed throughout the year. Payback answer may have decimal places, but reported in absolute terms (no negative numbers).
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