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)