For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste
Fantastic news! We've Found the answer you've been seeking!
Question:
For the following organisation, calculate the undiscounted 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 | - | 900 | 1000 | 1100 | 1200 | 1300 | |||||||
Net Sales | - | ||||||||||||
Variable Costs | - | $54,000 | $60,000 | $66,000 | $72,000 | $78,000 | |||||||
Fixed Costs | - | $15,000 | $15,750 | $16,538 | $17,364 | $18,233 | |||||||
Depreciation | - | $13,000 | $13,000 | $13,000 | $13,000 | $13,000 | |||||||
PBIT | - | ||||||||||||
Tax@40% | - | ||||||||||||
NOPAT | - | ||||||||||||
Adjustments | |||||||||||||
Add back Depreciation | - | ||||||||||||
CapEx | $100,000 | - | - | - | - | - | |||||||
Salvage value | - | - | - | - | - | $40,000 | |||||||
Net cash flow | |||||||||||||
Cumulative cash flow |
Related Book For
Concepts in Federal Taxation
ISBN: 9780324379556
19th Edition
Authors: Kevin E. Murphy, Mark Higgins, Tonya K. Flesher
Posted Date: