Question

You plan to break ground for a new building that has 30 2-bedroom apartments. The new...

  1. You plan to break ground for a new building that has 30 2-bedroom apartments. The new building will cost $12,000000 including renovations that would last a year (i.e., you would not have a tenant for a year. The interest rate for commercial loan is 5% per annum. You would pay the money upfront making $0 down payment. You are taking a 30-year loan with no balloon payment. The loan is estimated to being in January 2020 when you expect to get occupations and supervise renovation (included in the price).
  1. Build out the amortization table complete with each period, beginning balance, payment, interest paid, principle paid, and the ending balance.
  2. You believe that on an average you would have 1 apartment unoccupied all the time and you would be able to get a rent of $1500 per month. You collect the rent for the whole year at the time of leasing (on December 31st for the following year). You contribute whatever you save (or loose) as additional payment. Prepare another mortgage table and answer the following:
  1. By which year would be able to payoff the mortgage?
  2. What would be the payment that year?

Homework Answers

Answer #1

​​​​​​

NOTE : ACCORDING TO MY KNOWLEDGE. I HAVE ANSWERED ONLY A BIT . THANKS

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You plan to buy a house that has the sale price of $180,000. A local bank...
You plan to buy a house that has the sale price of $180,000. A local bank can offer you a conventional 30-year mortgage with 20% down payment and 4% APR. The bank also charge you 2% fees off the loan amount, including origination fee, document fee and etc. How much would be your upfront payment and monthly mortgage payment (a) Upfront payment (b) Monthly mortgage payment
You are planning to purchase a house for $180,000. You will pay 20% down payment and...
You are planning to purchase a house for $180,000. You will pay 20% down payment and take a mortgage loan for the remaining 80%. You could get a 3/1 ARM amortized over 15 years at 3.9 % or a fixed 15 year FRM loan at 5.3%. The expected interest rate of the ARM from years 4 to 5 is 7.5%. You will live in the house for five years, and after that you expect to sell the house for $200,000...
Suppose you are planning to develop a new apartment building next to Iowa State. You anticipate...
Suppose you are planning to develop a new apartment building next to Iowa State. You anticipate that the project will take two years to develop at a total cost of $3,000,000. Once open, you expect the building to produce a Net Operating Income of $250,000 annually. You’ve arranged a financing package that covers the construction period with a two-year interest only (IO) loan offered at loan-to-value ratio of 80% and an annual interest rate of 6%. Once the building opens,...
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home....
You plan to take a 30-year mortgage in the amount of $800,000 to buy a home. The bank charges 5.5% annual interest compounded monthly. You are going to pay off this loan by fixed installments (fixed total payment) to be made at the end of each month for thirty years. How much is each installment payment? How much is the total principal repayment after four months? How much is the total interest payment after four months. Draw an amortization table...
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has...
Solve using excel: A. Suppose you are considering the purchase of an apartment building that has 12 units that can be rented out at $1,050 per month. You have estimated operating expenses and expected vacancy and collection losses for the first year to be $35,700 and $30,240, respectively. You also have estimated that you will be able to generate an additional $3,840 in the first year from garage rentals on the property. If the expected purchase price of the property...
The Hobbes Corporation took out a 30-year mortgage on a new headquarters building on June 30,...
The Hobbes Corporation took out a 30-year mortgage on a new headquarters building on June 30, 2016 for $5,000,000 and pledged its only manufacturing facility and the land on which it stands as collateral. The monthly payment to the mortgagor is $22,452.23 and was first paid on July 1, 2016. Your firm has audited this client before, but the client has never had a mortgage in previous years. You are in charge of the current year audit for Thomas, which...
You need a 30-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank...
You need a 30-year, fixed-rate mortgage to buy a new home for $240,000. Your mortgage bank will lend you the money at a 9.1 percent APR for this 360-month loan. However, you can afford monthly payments of only $950, so you offer to pay off any remaining loan balance at the end of the loan in the form of a single balloon payment. Required: How large will this balloon payment have to be for you to keep your monthly payments...
Part 2 (matlab) Functions Many of you will have some form of a loan during your...
Part 2 (matlab) Functions Many of you will have some form of a loan during your lifetime, either a student loan, mortgage, credit card debt, or other loan. If you never do have a loan, great! But you may have to calculate a payment for someone else, such as the company you work for. Such a loan will have a principal amount (called the present value), an interest rate, and a number of periods for the loan. The formula to...
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with...
2.   Suppose you have decided to buy a house. The mortgage is a 30-year mortgage with an interest rate of 7%, compounded monthly. You borrow a total of $250,000. Given this, by the time you pay off the loan, how much in total (interest + principal) would the house cost you? (20 pts) 3.   How, reconsider the previous problem. Suppose you pay the mortgage according to those specifications (7% APR, monthly) for the first 10 years, but then you refinance...
Please analyze, from the perspective of finance, the choice of buying a house vs renting an...
Please analyze, from the perspective of finance, the choice of buying a house vs renting an apartment. To make a quantitative analysis, suppose you have collected the following information: If you rent a 1,000 sq ft two-bedroom apartment in RTP area, your monthly rent will be $900. The apartment is in move-in condition. You won’t have any upfront expenses when you move in. If you want to buy a house, a 2,000 sq ft three-bedroom townhouse in RTP area is...