For the following income statement summary, calculate the cumulative cash flow. You can do it in Excel and paste the result below. Year 0 1 2 3 4 5 Unit Price $105 $110 $115 $120 $125 Units Sold Net Sales 900 1000 1100 1200 1300 Cost of Sales $54,000 $60,000 $66,000 $15,000 $15,750 $16,538 $17,364 $18,233 $13,000 $13,000 $13,000 $13,000 $13,000 $72,000 $78,000 Fixed Costs Depreciation PBIT Tax@40% NOPAT Adjustments Add back Depreciation CapEx ($100,00 0) Salvage value Net cash flow Cumulative cash flow $40,000
For the following income statement summary, calculate the cumulative cash flow. You can do it in Excel and paste the result below. Year 0 1 2 3 4 5 Unit Price $105 $110 $115 $120 $125 Units Sold Net Sales 900 1000 1100 1200 1300 Cost of Sales $54,000 $60,000 $66,000 $15,000 $15,750 $16,538 $17,364 $18,233 $13,000 $13,000 $13,000 $13,000 $13,000 $72,000 $78,000 Fixed Costs Depreciation PBIT Tax@40% NOPAT Adjustments Add back Depreciation CapEx ($100,00 0) Salvage value Net cash flow Cumulative cash flow $40,000
Chapter10: Financial Statements And Reports
Section: Chapter Questions
Problem 3.5C
Related questions
Question
Transcribed Image Text:For the following income statement summary, calculate the cumulative cash flow. You can
do it in Excel and paste the result below.
Year
0
1
2
3
4
5
Unit Price
$105
$110
$115
$120
$125
Units Sold
Net Sales
900
1000
1100
1200
1300
Cost of Sales
$54,000 $60,000
$66,000
$15,000 $15,750 $16,538 $17,364 $18,233
$13,000 $13,000 $13,000 $13,000 $13,000
$72,000 $78,000
Fixed Costs
Depreciation
PBIT
Tax@40%
NOPAT
Adjustments
Add back
Depreciation
CapEx
($100,00
0)
Salvage value
Net cash flow
Cumulative cash
flow
$40,000
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you