Excel calculation; Financial statement : Real Estate please read this through and calculate information in excel for me; You have a company that owns and rents out real estates You take a loan for 150.000? for 20 years (int 2%/y)/ 31.12.2012 You buy a small warehouse for 150.000? / 31.12.2012 You rent out the warehouse for 800?/mth (9600?/year)/ 1.1.2013- Your maintenance charge in 150?/mth (1800?/year)/ 1.1.2013- Repayment of loan 7500? / 31.12.2013 Interest 3000? / 31.12.2013 OBS! The maintenance charge is a cost that covers everything to secure that the warehouse keeps it value at the same level For this single investment What is your EBIT for the year 2013? What is your ROI for the year 2013? How does the balance sheet look like at the end of 2012 and 2013 Explain the cash flows in 2012 and 2013 (very short)