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

*please calculate irr in excel
Cash Flow from Operations Sales Cost of goods sold Gross income Operating

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!