MyCrystalBalls - Investment Depreciation Tax Rate Discout...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Investment $30,000,000.00 Depretiation Amount Book Value 1 2 3 4 5 6 7 8 9 10 Depreciation MACR 1 14.29% $4,287,000.00 $25,713,000.00 Market Size 500000 520000 540800 562432 584929.28 608326.4512 632660 657966 684285 711656 Tax Rate 34% 2 24.49% $7,347,000.00 $18,366,000.00 Discout project cashflows 20% 3 17.49% $5,247,000.00 $13,119,000.00 Units Sold 30000 31200 32448 33745.92 35095.7568 36499.587072 37959.57 39478 41057.07 42699.35 Initial Market Size 500000 4 12.49% $3,747,000.00 $9,372,000.00 Growth in Market Size 4% 5 8.93% $2,679,000.00 $6,693,000.00 Market Share 6% 6 8.93% $2,679,000.00 $4,014,000.00 Unit Price $3,900.00 7 8.93% $2,679,000.00 $1,335,000.00 Unit Variable Cost $2,800.00 8 4.45% $1,336,200.00 $- Fixed Cost $25,000,000.00 Marekting Exepnse as a % of Rev 2% 0 1 2 3 4 5 6 7 8 9 10 Units Sold 30000 31200 32448 33745.92 35095.7568 36499.587072 37959.57055488 39477.9533770752 41057.0715121582 42699.3543726445 Price per unit $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 $3,900.00 cost per unit $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 $2,800.00 revenue $117,000,000.00 $121,680,000.00 $126,547,200.00 $131,609,088.00 $136,873,451.52 $142,348,389.58 $148,042,325.16 $153,964,018.17 $160,122,578.90 $166,527,482.05 Variable Costs $84,000,000.00 $87,360,000.00 $90,854,400.00 $94,488,576.00 $98,268,119.04 $102,198,843.80 $106,286,797.55 $110,538,269.46 $114,959,800.23 $119,558,192.24 Marketing Expense $2,340,000.00 $2,433,600.00 $2,530,944.00 $2,632,181.76 $2,737,469.03 $2,846,967.79 $2,960,846.50 $3,079,280.36 $3,202,451.58 $3,330,549.64 Fixed costs $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 $25,000,000.00 EBITDA $5,660,000.00 $6,886,400.00 $8,161,856.00 $9,488,330.24 $10,867,863.45 $12,302,577.99 $13,794,681.11 $15,346,468.35 $16,960,327.09 $18,638,740.17 Less: Depreciation Expense ($4,287,000.00) ($7,347,000.00) ($5,247,000.00) ($3,747,000.00) ($2,679,000.00) ($2,679,000.00) ($2,679,000.00) $(1,335,000.00) $0.00 $0.00 EBIT $1,373,000.00 $(460,600.00) $2,914,856.00 $5,741,330.24 $8,188,863.45 $9,623,577.99 $11,115,681.11 $14,011,468.35 $16,960,327.09 $18,638,740.17 Less: Taxes $(466,820.00) $156,604.00 $(991,051.04) $(1,952,052.28) $(2,784,213.57) $(3,272,016.52)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

MyCrystalBalls - Investment Depreciation Tax Rate Discout...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online