{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Project Final

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

This preview shows pages 1–3. Sign up to view the full content.

Tim Carroll 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 8% 18899.19 400 412285.28 10% 18899.19 500 608978.32 12% 18899.19 600 805671.37 15% 18899.19 700 1002364.41 17% 18899.19

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

View Full Document
Tim Carroll 5 6 7 8 9 10 11 \$80,000.00 \$80,000.00 \$80,000.00 \$80,000.00 \$80,000.00 \$80,000.00 \$100,000.00 \$50,000.00 \$50,000.00 \$50,000.00 \$50,000.00 \$50,000.00 \$50,000.00 \$60,000.00 \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 \$29,000.00 \$29,000.00 \$29,000.00 \$29,000.00 \$29,000.00 \$29,000.00 \$39,000.00 \$8,700.00 \$8,700.00
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 3

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

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

View Full Document
Ask a homework question - tutors are online