Excel Project Final

Excel Project Final - Tim Carroll Cost Equipment Land Sales...

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

View Full Document Right Arrow Icon
Cost Equipment $20,000.00 Sales Increase $20,000 Land $150,000.00 Cost Increase $10,000 Sales $80,000 Crates Sold per Year 200 Operating Expenses $50,000.00 Salvage Value $- Tax Rate 30% Net Present Value $18,899.19 Req Rate 13% IRR 14% Year 0 1 2 3 4 Sales $80,000.00 $80,000.00 $80,000.00 $80,000.00 Costs $50,000.00 $50,000.00 $50,000.00 $50,000.00 Depreciation $1,000.00 $1,000.00 $1,000.00 $1,000.00 Taxable $29,000.00 $29,000.00 $29,000.00 $29,000.00 Taxes $8,700.00 $8,700.00 $8,700.00 $8,700.00 Net Income $20,300.00 $20,300.00 $20,300.00 $20,300.00 + Deprec $1,000.00 $1,000.00 $1,000.00 $1,000.00 Cash Flow $21,300.00 $21,300.00 $21,300.00 $21,300.00 Equipment $(20,000.00) Land $(150,000.00) Total $(170,000.00) $21,300.00 $21,300.00 $21,300.00 $21,300.00 Value of Land When Bought Appreciation Value After 20 yrs. Appreciation Capital Gain on Land Income Tax $150,000 5% $397,994.66 $247,994.66 $74,398.40 Crates NPV Land Net Present Value 200 $18,899.19 5% $18,899.19 300 215592.24
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 / 3

Excel Project Final - Tim Carroll Cost Equipment Land Sales...

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