You are consdering buying an apartment building on Green Street that you will then rent out...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are consdering buying an apartment building on Green Street that you will then rent out to students. The property you are examining will cost you $15,000,000 and it has 40 rental units. 25 of those rental units are quads that you think you will be able to rent out for $2,400/unit per month. The other 15 rental units are doubles that you are thinking you can rent out for $1,600/unit per month. There is also a parking garage that has 50 spots that you estimate you can rent out for $900/year. Leases will be 12-months long and you omit the securitiy deposit fee from your IRR calculation. This apartment building is very nice and you coservatively estimate that you can achieve a 85% occupancy rate for both the quads and the doubles each year. You estimate you can achieve 100% occupancy for the parking spots. You expect you will have maintence/improvement fees of $75,000/year and you expect those fees to increase 2% every year as the building ages. Utilities are included in the rental rate already and you figure utilities will cost you $200/unit per month. You assume a fixed value of $700,000/year for the real estate and income taxes. Assume you purchase the property at the end of Year 0 and will sell the property at the end of Year 15 for $20,000,000. Using this infromation, build out the cash flow of this project similar to the first in class practice problem. Clearly label your work. Also calculate the IRR of this project and clearly label it. I expect everyone's format to be alitle different but you should all receive the same IRR. You will recieve full credit for this question if you show your work below, label each line item, and have the correct IRR. Feel free to use as much space as you'd like and add sheet rows as needed. Project Details Quad Rental Rate Number of Quads Double Rental Rate Number of Doubles Parking Spot Rate Number of Parking Spots Maintenance Fee Base Maintenance Fee % Increase Utilities/month Taxes $2,400 per month 25 Units $1,600 per month 15 units $900 year 50 $75,000 year 2% every year the building ages $200 $700,000 year Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Report IRR Here --> You are consdering buying an apartment building on Green Street that you will then rent out to students. The property you are examining will cost you $15,000,000 and it has 40 rental units. 25 of those rental units are quads that you think you will be able to rent out for $2,400/unit per month. The other 15 rental units are doubles that you are thinking you can rent out for $1,600/unit per month. There is also a parking garage that has 50 spots that you estimate you can rent out for $900/year. Leases will be 12-months long and you omit the securitiy deposit fee from your IRR calculation. This apartment building is very nice and you coservatively estimate that you can achieve a 85% occupancy rate for both the quads and the doubles each year. You estimate you can achieve 100% occupancy for the parking spots. You expect you will have maintence/improvement fees of $75,000/year and you expect those fees to increase 2% every year as the building ages. Utilities are included in the rental rate already and you figure utilities will cost you $200/unit per month. You assume a fixed value of $700,000/year for the real estate and income taxes. Assume you purchase the property at the end of Year 0 and will sell the property at the end of Year 15 for $20,000,000. Using this infromation, build out the cash flow of this project similar to the first in class practice problem. Clearly label your work. Also calculate the IRR of this project and clearly label it. I expect everyone's format to be alitle different but you should all receive the same IRR. You will recieve full credit for this question if you show your work below, label each line item, and have the correct IRR. Feel free to use as much space as you'd like and add sheet rows as needed. Project Details Quad Rental Rate Number of Quads Double Rental Rate Number of Doubles Parking Spot Rate Number of Parking Spots Maintenance Fee Base Maintenance Fee % Increase Utilities/month Taxes $2,400 per month 25 Units $1,600 per month 15 units $900 year 50 $75,000 year 2% every year the building ages $200 $700,000 year Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Report IRR Here -->
Expert Answer:
Answer rating: 100% (QA)
To build out the cash flow of the project we will calculate the annual cash inflows and outflows for each year based on the provided information Heres ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
From the following estimate total sales: Cash sales Rs. 20,000, Cash collection from debtors Rs. 130,000, bad debts during the year 15,000, Cash discount to debtors Rs. 5000. Debtors as on 1.1.2014...
-
James D. Harmon, Jr., owns an apartment building on West 76th Street near Central Park in New York City. Three of his apartments are subject to rent control, a long-time city program designed to...
-
George Buckner sells an apartment building on October 10 for Si 75 million. The building was purchased on January 1, 1996, for $2 million. Depreciation of $420,000 has been taken. The figures given...
-
QUESTION 5 Discuss the difference between the following:(a) Functional & non-functional requirements(b) User & system requirements T T T Arial ABC 3 (12pt) T Path: p Words:0
-
Filimonov Savings Bank pays 8 percent interest compounded weekly (0.154 percent per week) on savings accounts. The bank has asked your help in preparing a table to show potential customers the number...
-
The total assets and total liabilities of Coca-Cola and PepsiCo are shown below. Determine the owners' equity of each company. Coca-Cola (in millions) Pepsico (in millions) Assets Liabilities $29,963...
-
When two parallel plates separated by a distance \(d\) are connected to a battery that maintains a potential difference of magnitude \(V\) between the plates, a charge of magnitude \(q\) accumulates...
-
Rockness Recycling refurbishes rundown business students. The process uses a moving belt, which carries each student through the five steps of the process in sequence. The five steps are as follows:...
-
1. A planet is revolving around the sun in an elliptical orbit. The mass of planet is m, angular momentum of planet about sun is L, and length of semi major axis is a and eccentricity is e. Time...
-
A block on a frictionless table is connected as shown in FIGURE P15.75 to two springs having spring constants k 1 and k 2 . Find an expression for the blocks oscillation frequency f in terms of the...
-
Stella's mortgage on her main home is $1 million and meets all the qualifications for the Mortgage Interest Deduction. She is a joint filer and paid $60,000 in interest for 2023. Stella can claim the...
-
What are commonly used Terraform commands? A. init, plan, apply, graph, refresh, destroy, taint, untaint B. variable, resource, provider C. oci D. create, delete, get, list, update
-
Cognitive learning theorists are concerned only with overt behavior, not with its internal causes. True or false?
-
What happens when we sleep, and what are the meaning and function of dreams?
-
Which of the following statements are true? A. Terraform may only be used to manage OCI resources. B. Terraform is an Oracle technology. C. Terraform may be used to manage infrastructure from many...
-
How might it be possible to have sensation without perception? Conversely, might it be possible to have perception without sensation?
-
Using Applets. Create a project named TaskPerf'lll. Draw your game characters and props using your preferred graphics software. save them in PNG format. Create a simple game {with events} that use :...
-
In muscle tissue, the ratio of phosphorylase a to phosphorylase b determines the rate of conversion of glycogen to glucose 1phosphate. Classify how each event affects the rate of glycogen breakdown...
-
On rare occasions, an organism may have three copies of a chromosome and therefore three copies of the genes on that chromosome (instead of the usual number of two copies). The alleles for each gene...
-
Explain how the miR-200 family of miRNAs behave as tumorsuppressor genes. What happens when their expression is blocked or decreased?
-
Outline the steps that occur when piRITS or piRISC silences transposable elements by repressing transcription and by directly inhibiting TE RNAs, respectively. What is the role of piRNAs in this...
Study smarter with the SolutionInn App