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 10% 20 Interest Term Payments per Year Years Since Purchased years 12 New Loan Information: Interest Rate 2 11% 12 2 9 New Loan Information: Interest Rate Term Payments per Year 11% 20 years $100,000 2% per year $1.050.000 2% per year 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 12 39 years 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 cash flows 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 Accumulated Depreciation for Scenario A, used in computing the ATCF from reversion? (round your final answer to whole numbers) Cash Flows With Renovation As in Part A Additional Equity Investment Loan Amount Annual Loan Payment $50,000 $873 879 $108.241 8 New Loan Information Year Interest EOY Loan Balance 2 $0 $873,879 3 $95,497 $861,135 4 5 6 7 $94.022 $92,377 $90,541 $88,493 $846.917 $831,052 $813,352 $793,604 $86,208 $771,571 8 Year Debt Service BTCF $139,113 3 $120,000 $108.241 $11,759 4 5 6 7 $123,600 $127,308 $131,127 $135,061 $ 108 241 $108,241 $108,241 $108,241 $15,359 $19,067 $22,886 $26,820 PIT Taxable Income NOI Less Interest Less Depreciation Taxable income Tax $120,000 $95,497 2 ($1,138) ? $123,600 $127,308 $131,127 $135,061 $94,022 $92,377 $90,541 $88,493 ? P ? $3,937 $9,290 $14.945 $20,927 ? ? ? ? Tax ? ? ? ATOF BTCF Tax ATOF $11,759 ($319) ? $ 15,359 $1,102 $19,067 $2,601 ? $22,886 $26,820 $4,185 $5,860 ? ? Cash Flows from Sale in Year 7 Sales Price Sales Cost Mortgage Balance BTCF (sale) $1,391,129 $55,645 $793,604 $541,879 Sales Price Sales Costs Original Cost basis Price Appreciation Accumulated Depreciation $1,391,129 $55,645 $1,200,000 $135,484