Question: *please calculate irr in excel Cash Flow from Operations Sales Cost of goods sold Gross income Operating expenses: Business Real estate Lease payments Interest Depreciation
Cash Flow from Operations Sales Cost of goods sold Gross income Operating expenses: Business Real estate Lease payments Interest Depreciation Taxable income Tax Income after tax Plus: Depreciation After-tax cash flow Reversion/owning Mortgage balance Reversion Basis Gain Tax After-tax cash flow $1.500,000 750,000 750,000 200,000 70,000 o 50.400 40,385 389.215 81.735 307,480 40,385 347,865 Lease $1.500,ooo 750,000 750.000 200,000 70,000 140,000 340.000 71 ,400 268,600 268.600 Cash Flow from Sale -1,194,231 1,805,769 Difference (Own Lease) o o o o -140,000 50,400 40,385 49,215 10,335 38,880 40,385 79,265 3,000,000 -1.260,000 -379,212 1,360,788
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
