Rambo presently owns the Marine Tower office building, which is 20 years old, and is considering renovating it. He purchased the property 2 years ago for $1,000,000 and financed it with a 20-year, 75% loan at 10% interest (monthly payments). Of the $1,000,000, the appraiser indicated that the land was worth $200,000 and the building $800,000. Rambo has been using straight line depreciation over 39 years and for simplicity purposes, does not include any mid-month conventions for year 1 (1/39 per year for simplicity). At the present time Marine Tower is producing $100,000 in NOI (Year3), and the NOI and property value are expected to increase 2% per year. The current market value of the property is $1,050,000. Rambo estimates that if the Marine Tower office building is renovated at a cost of $200,000, NOI will be about 20% higher next year ($120,000 vs $100,000) due to higher rents and lower expenses. He also expects that with renovation the NOI will increase 3% per year instead of 2%. Furthermore, Rambo believes that after 5 years, a new investor will purchase the Marine Tower office building at a price based on capitalizing the projected NOI 6 years from now (2 years have passed and an additional 6 years, giving a total of 8 years) at 10% terminal capitalization rate. Selling costs would be 4% of the sale price. Rambo is currently having to pay a 28% tax on ordinary income, 28% on price appreciation, and 28% on depreciation recapture, which he expects to remain the same in the future. He also would not be subject to any passive activity loss limitations. If Rambo does the renovation, he believes that he could obtain a new loan at 11% interest rate and a 20-year loan term (monthly payments). Below is the summary of the information about the property, and his estimation if he does the renovation. CURRENT $1,000,000 Purchase Price Building Value Land Value Loan-to-value Ratio $800,000 $200.000 75% IF RENOVATED Renovation Cost $200.000 Initial Increase in NOI (Year 3) 20% Annual Increase in NOI 3% Terminal Cap Rate 10% of sale Selling Expenses 4% price Interest 10% 20 years 12 New Loan Information: 2 11% Interest Rate Term Payments per Year 20 years 12 Term Payments per Year Years Since Purchased Current NOI (Year 3) Projected Increase in NOI Resale Value Today Appreciation Rate Depreciable Life Ordinary Income Tax Rate Price Appreciation Tax Rate Depreciation Recapture Tax Rate $100.000 2% per year $1.050.000 2% per year 39 year's 28% 28% 28% A. Assume that if Rambo does the renovation, he will be able to obtain a new loan that is equal to the balance of the existing loan plus 75% of the renovation costs. Below is what the incremental cash flows without and with renovation looks like, which is from the scenario A. Assume a five-year holding period. Some cells have been intentionally left empty. Please compute them as needed to solve what is being asked. What is the ATIRR on Equity for the Incremental Cash flows for Scenario A? (round your final answer to 2 decimal points) What is the ATIRR on Equity for the Incremental Cash flows for Scenario A? (round your final answer to 2 decimal points) Incremental Analysis - Renovation versus No Renovation as in Part A Year 2 5 7 ? $12,078 $14,257 $16,466 $18,702 ? ATCF with Renovation ATCF with No Renovation ? $10,969 $11,965 $12,944 $13,900 ? Incremental CF ? ? ? ? ATIRR on Equity ? Rambo presently owns the Marine Tower office building, which is 20 years old, and is considering renovating it. He purchased the property 2 years ago for $1,000,000 and financed it with a 20-year, 75% loan at 10% interest (monthly payments). Of the $1,000,000, the appraiser indicated that the land was worth $200,000 and the building $800,000. Rambo has been using straight line depreciation over 39 years and for simplicity purposes, does not include any mid-month conventions for year 1 (1/39 per year for simplicity). At the present time Marine Tower is producing $100,000 in NOI (Year3), and the NOI and property value are expected to increase 2% per year. The current market value of the property is $1,050,000. Rambo estimates that if the Marine Tower office building is renovated at a cost of $200,000, NOI will be about 20% higher next year ($120,000 vs $100,000) due to higher rents and lower expenses. He also expects that with renovation the NOI will increase 3% per year instead of 2%. Furthermore, Rambo believes that after 5 years, a new investor will purchase the Marine Tower office building at a price based on capitalizing the projected NOI 6 years from now (2 years have passed and an additional 6 years, giving a total of 8 years) at 10% terminal capitalization rate. Selling costs would be 4% of the sale price. Rambo is currently having to pay a 28% tax on ordinary income, 28% on price appreciation, and 28% on depreciation recapture, which he expects to remain the same in the future. He also would not be subject to any passive activity loss limitations. If Rambo does the renovation, he believes that he could obtain a new loan at 11% interest rate and a 20-year loan term (monthly payments). Below is the summary of the information about the property, and his estimation if he does the renovation. CURRENT $1,000,000 Purchase Price Building Value Land Value Loan-to-value Ratio $800,000 $200.000 75% IF RENOVATED Renovation Cost $200.000 Initial Increase in NOI (Year 3) 20% Annual Increase in NOI 3% Terminal Cap Rate 10% of sale Selling Expenses 4% price Interest 10% 20 years 12 New Loan Information: 2 11% Interest Rate Term Payments per Year 20 years 12 Term Payments per Year Years Since Purchased Current NOI (Year 3) Projected Increase in NOI Resale Value Today Appreciation Rate Depreciable Life Ordinary Income Tax Rate Price Appreciation Tax Rate Depreciation Recapture Tax Rate $100.000 2% per year $1.050.000 2% per year 39 year's 28% 28% 28% A. Assume that if Rambo does the renovation, he will be able to obtain a new loan that is equal to the balance of the existing loan plus 75% of the renovation costs. Below is what the incremental cash flows without and with renovation looks like, which is from the scenario A. Assume a five-year holding period. Some cells have been intentionally left empty. Please compute them as needed to solve what is being asked. What is the ATIRR on Equity for the Incremental Cash flows for Scenario A? (round your final answer to 2 decimal points) What is the ATIRR on Equity for the Incremental Cash flows for Scenario A? (round your final answer to 2 decimal points) Incremental Analysis - Renovation versus No Renovation as in Part A Year 2 5 7 ? $12,078 $14,257 $16,466 $18,702 ? ATCF with Renovation ATCF with No Renovation ? $10,969 $11,965 $12,944 $13,900 ? Incremental CF ? ? ? ? ATIRR on Equity