Using the example below, could you demonstrate what would happen if you had a tax rate of 25%, depreciation expense for the BUY scenario of $5,000, projected income of $15,000 for years 1 - 5. Can you show how you calculate the Internal Rate of Return (doing this in Excel) and Future Value? If you can put it all in tables just like below that would be great because it is clear to see and easier to understand. Thank you.

For Example, Initial investment required Annual operaring costs Salvage value of investment Working capital required Cost of capital Length of the project $100,000 $7,000 $20,000 $10,000 10% 5 years Year Initial investment required Annual operaring costs Salvage value of investment Working capital required Working capital recovery Total Cash Outflows Discounting Factor @ 10% Discounted Cash Flows 0 3 $100,000 $7,000 $7,000 $7,000 $7,000 $7,000 ($20,000) 10,000 $110,000 1.0000 $110,000 $7,000 0.9091 $6,364 $7,000 0.8264 $5,785 $7,000 0.7513 $5,259 $7,000 0.6830 $4,781 ($10,000) ($23,000) 0.6209 ($14,281) Present worth of cash flows 117,908 [Sum of discounted cash flows from year-0 thru year-5] Annual lease payments Annual operating expenses Working capital required Cost of capital Length of the project $25,000 $2,000 $5,000 10% 5 years Year Annual lease payments Annual operating expenses Working capital required Working capital recovery Total Cash Outflows Discounting Factor @ 10% Discounted Cash Flows 0 $25,000 $2,000 $25,000 $2,000 $25,000 $2,000 4 25,000 $2,000 $25,000 $2,000 $5,000 $5,000 1.0000 $5,000 $27,000 0.9091 $24,545 $27,000 0.8264 $22,314 $27,000 0.7513 $20,285 $27,000 0.6830 $18,441 ($5,000) $22,000 0.6209 $13,660 Present worth of cash flows $104,247[Sum of discounted cash flows from year-0 thru year-5]