You can purchase a 10,000 square foot office building for $1,900,000. You can finance your purchase with an 80% loan at 4.675% interest, requiring monthly payments over 25 years. Rents are $24.00 per square foot and expenses are $10.00 per square foot. You project vacancy to be 12% in years 1 and year 2, 8% in year 3 then 6% thereafter. You expect that rents will increase by 6% per year for years 2 and 3, then increase by 4% thereafter. You believe that expenses willincrease at a fixed rate of 5% per year. You expect to sell the building on a 7 cap, based on the following year’s income. For a holding period of 8 years. What is the (BEFORE TAX): Before Tax IRR on Equity ? Before Tax NPV @ 12% ?

You can purchase a 10,000 square foot office building for $1,900,000. You can finance your purchase with an 80% loan at 4.675% interest, requiring monthly payments over 25 years. Rents are $24.00 per square foot and expenses are $10.00 per square foot. You project vacancy to be 12% in years 1 and year 2, 8% in year 3 then 6% thereafter. You expect that rents will increase by 6% per year for years 2 and 3, then increase by 4% thereafter. You believe that expenses willincrease at a fixed rate of 5% per year. You expect to sell the building on a 7 cap, based on the following year’s income. For a holding period of 8 years. What is the (BEFORE TAX): Before Tax IRR on Equity ? Before Tax NPV @ 12% ?

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

1. You are purchasing a home for $150,000 at an 8% APR. Your loan period is 360 months. If your payment is $1,100.65, what is your loan balance after 10 years? $104,658 $131,586 $135,386 $121,543 2. You are purchasing a home for $150,000 at an 8% APR. Your loan period is 360 months. If your payment is $1,100.65, what will your equity be after 10 years? $18,414 $28,627 $14,538 $34,579
You are considering the purchase of a property today for $400,000. You plan to finance 60.00% of the purchase price with a loan. The appreciation rate on the property value is expected to be 5.00% annually for the next three year Calculate the EAHE. please work it out in excel
You finish your engineering degree with $17,350 in student loans. The interest rate on your loans is 0.6% per month. The loan repayment period is 10 years and your monthly payment is set to be $203.24 [= $17,350(A/P, 0.6%, 120)]. Question 2: The total interest dollars repaid using the shorter is $2,750. How total interest would be repaid using the 10-year repayment plan?
An apartment building in your neighborhood is for sale for $175,000. The building has four units, which are rented at $550 per month each. The tenants have long-term leases that expire in 7 years. Maintenance and other expenses for care and upkeep are $9500 annually. A new university is being built in the vicinity and it is expected that the building could be sold for $198,000 after 7 years. What is the internal rate of return for this investment?
You want to purchase an office building in Brooklyn that is expected to generate $475554 net operating income (NOI) in the following year. You decide you want to take out a loan to finance the purchase of this property. It will be an IO loan at a rate of 6.82%, compounded annually, with annual payments. The lender will provide financing up to a minimum Debt Service Coverage Ratio (DSCR) of 1.2 based off the next year's NOI. What is the largest loan amount the lender will allow you to take based on the DSCR requirement? State your answer as a number rounded to the nearest cent (e.g. if you get $13.57654, write 13.58)
You are considering purchasing a new automobile with the upfront cost of $26,000 or leasing it from the dealer for a period of 48 months. The dealer offers you 2.80% APR financing for 5 years (with payments made at the end of the month). Assuming you finance the entire $26,000 through the dealer, your monthly payments will be closest to $425.09 $429.11 O $473.25 $428.85
When purchasing a $100,000 house, a borrower is comparing two loan alternatives. The first loan is an 80% loan at 4% with monthly payments of $591.75 for 15 years. The second loan is 90% loan at 5% with monthly payments of $526.13 over 25 years. What is the incremental cost of borrowing the extra money assuming the loan will be held for the full term? O 6.50% O 13.21% O 7.20% O 13.70%
Assume you are preparing to move into a new neighborhood. You are considering renting or buying. Divide your team into two groups. Requirements Group 1 will analyze the renting option. A suitable rental is available for $500 per month, and you expect rent to increase by $50 per month per year. Prepare a schedule showing rent payments for the next 15 years. To simplify the problem, assume rent is paid annually. Using 5% as the discount rate, determine the present value of the rent payments. Round present value amounts to the nearest dollar. Group 2 will analyze the buying option. A suitable purchase will require financing $105,876 at 5%. Annual payments for 15 years will be $10,200 (annual payments assumed to simplify the problem). Calculate the present value of the payments. Additionally, using Excel with appropriate formulas, prepare a payment schedule with the following columns (year 1 is completed as an example): After each group has prepared its schedule, meet as a full team to…
Suppose you have a student loan of $50,000 with an APR of 12% for 40 years. Complete parts (a) through (c) below. a. What are your required monthly payments? b. Suppose you would like to pay the loan off in 15 years instead of 30. What monthly payments will you need to make? c. Compare the total amount you'll pay over the loan term if you pay the loan off in 15 years versus 30 years.
16. You borrow $27,000 to purchase a plane. The loan will be paid in monthly installments over one year at 30% interest annually. The first payment is due one month from today. What is the amount of each monthly payment? (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)
The executive of a label is looking to purchase a new rental for $3.9 million. Financing is offered for a 3.9% rate over 6 years. If $800,000 is place down towards the entire purchase, what will the monthly payment for the loan be? Use Excel functions to complete the calculation.
Please solve via excel and show calculation steps to solve table. Scenario: You have decided to finance a new home. The loan is for $248,000 and you are getting a rate of 5.9% per year compounded monthly. You have decided on a 15-year mortgage and will make monthly payments (end of the month). You decided you will pay 5% down at the beginning. You are working extra hours and expect to pay an extra $350 per month to knock down the principle. You make these payments for 6 years starting on month 25. The last EXTRA payment is on month 96. Build the amortization table. What month will you make your last payment? How much will your last payment be?