You vill eed you to create an excel spreadsheet /oroforma of the cash flows from a property. expenses, capital over a holding period through the sale. Below are is all the information that you need to This assignment is to create an analysis for purchasing a property, projecting rents, expense do the cakculations and determine the metrics behind the investment. Market rent S30/sf for gross leases S22/sf for net leases Growth rate 3% annually for everything Rent Roll Tenant SF Rent/yr sf Stop Lease Start Mo. Term Steps Tenant A 25,000 $33.00 BY $9.40/sf 1 10yrs 396/year $32/sf in yr 5 Tenant B 30,000 $27.00 BY 8.50/sf1 Tenant C 35,000 $20.00 Net 1 Tenant 10,000 $30.00 BY $10.00/sf 13 8 yrs 3 yrs 10 yrs 36 in month 67 N/A Total Base year (B) The tenant wil pay for expenses that have risen to a level above their expense stop. Net leases have a stop of zero, so they pay all reimbursable expense, Tenants A, B and D are modified gross with expenses passed through over a base year while tenant C is Net Vacancy/Credit Loss % of PG Expense Caregery Expense per foor homeworkt jpg homenorksjipg Ahomework2p9 Search the web and F4 2 4 OW ERT Y Expense Category Expense per foot R&M Insurance Utilities Payroll $ 5.00/sf $1.00/s S 0.25/sf S 2.00/sf $0.85/sf 0.50/sf S0.40/sf G&A Total Reimbursable $10.00/sf Non Reimbursable Management Assume zero rollover possibility. Downtime (vacancy at end of lease) 6 months Total Capital at rollover 25/sf growing at inflation From the above information, you should be able to create a proforma. 3% of EGI 7.5% 10.0% 5 years Discount Rate Term Amortization 30 vears pptppt homework1 jpg homeworka.jpg Search the web and F10 2 4 5 6 Tab 75% 10.0% 5 years 30 years 496 rate 70% Discount Rate Term Amortization Rate LTV Create a proforma for a five year hold aggregating the cash flows from each lease. Calculate Value IRR Cash flow after debt Service Cash on Cash Return Debt service coverage Ratio Leveraged IRR Debt Yielkd Break-even ratio Start by creating a column for each month of the hold periodt and additional 12 months-for the reveersion year. In these columns enter in the first line 1 increasing each month by 1. The next line put in the dates. Starting with 1/1/19 seems reasonable Then for each lease put in the monthly rent that is due for each month pptppt homework1.jpg Search the web and Windows 4 6 Tab Q W ER T Assume zero Tolover possianiny, Downtme (vacancy at end or leasejo montns Total Capital at rollover 25/sf growing at inflation From the above information, you should be able to create a proforma. Reversion Discount Rate Term Amortization Rate LTV Create a proforma for a five year hold aggregating the cash flows from each Calculate 75% 10.0% 5 years 30 years 496 rate 7096 lease. Value IRR Cash flow after debt Service Cash on Cash Return Debt service coverage Ratio Leveraged IRR Debt Yield Break-even ratio ppt.ppt homework 1,jpg homewiork3jpg Search the web and Windows You vill eed you to create an excel spreadsheet /oroforma of the cash flows from a property. expenses, capital over a holding period through the sale. Below are is all the information that you need to This assignment is to create an analysis for purchasing a property, projecting rents, expense do the cakculations and determine the metrics behind the investment. Market rent S30/sf for gross leases S22/sf for net leases Growth rate 3% annually for everything Rent Roll Tenant SF Rent/yr sf Stop Lease Start Mo. Term Steps Tenant A 25,000 $33.00 BY $9.40/sf 1 10yrs 396/year $32/sf in yr 5 Tenant B 30,000 $27.00 BY 8.50/sf1 Tenant C 35,000 $20.00 Net 1 Tenant 10,000 $30.00 BY $10.00/sf 13 8 yrs 3 yrs 10 yrs 36 in month 67 N/A Total Base year (B) The tenant wil pay for expenses that have risen to a level above their expense stop. Net leases have a stop of zero, so they pay all reimbursable expense, Tenants A, B and D are modified gross with expenses passed through over a base year while tenant C is Net Vacancy/Credit Loss % of PG Expense Caregery Expense per foor homeworkt jpg homenorksjipg Ahomework2p9 Search the web and F4 2 4 OW ERT Y Expense Category Expense per foot R&M Insurance Utilities Payroll $ 5.00/sf $1.00/s S 0.25/sf S 2.00/sf $0.85/sf 0.50/sf S0.40/sf G&A Total Reimbursable $10.00/sf Non Reimbursable Management Assume zero rollover possibility. Downtime (vacancy at end of lease) 6 months Total Capital at rollover 25/sf growing at inflation From the above information, you should be able to create a proforma. 3% of EGI 7.5% 10.0% 5 years Discount Rate Term Amortization 30 vears pptppt homework1 jpg homeworka.jpg Search the web and F10 2 4 5 6 Tab 75% 10.0% 5 years 30 years 496 rate 70% Discount Rate Term Amortization Rate LTV Create a proforma for a five year hold aggregating the cash flows from each lease. Calculate Value IRR Cash flow after debt Service Cash on Cash Return Debt service coverage Ratio Leveraged IRR Debt Yielkd Break-even ratio Start by creating a column for each month of the hold periodt and additional 12 months-for the reveersion year. In these columns enter in the first line 1 increasing each month by 1. The next line put in the dates. Starting with 1/1/19 seems reasonable Then for each lease put in the monthly rent that is due for each month pptppt homework1.jpg Search the web and Windows 4 6 Tab Q W ER T Assume zero Tolover possianiny, Downtme (vacancy at end or leasejo montns Total Capital at rollover 25/sf growing at inflation From the above information, you should be able to create a proforma. Reversion Discount Rate Term Amortization Rate LTV Create a proforma for a five year hold aggregating the cash flows from each Calculate 75% 10.0% 5 years 30 years 496 rate 7096 lease. Value IRR Cash flow after debt Service Cash on Cash Return Debt service coverage Ratio Leveraged IRR Debt Yield Break-even ratio ppt.ppt homework 1,jpg homewiork3jpg Search the web and Windows