Quickbooks Online Accounting
Quickbooks Online Accounting
3rd Edition
ISBN: 9780357391693
Author: Owen
Publisher: Cengage
Bartleby Related Questions Icon

Related questions

Question
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
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Quickbooks Online Accounting
Accounting
ISBN:9780357391693
Author:Owen
Publisher:Cengage