
Concept explainers
You have purchased a building for $12,000,000. There are ongoing NNN leases that will create a constant annual PGI of 1,700,000 with a Vacancy and Collection loss of 10%. Operating Expenses will be constant at 575,000 per year, and Capital Expenditures a constant 120,000 per year. You have obtained a 5-year, 4.5% partially amortizing loan at 65%LTV with 1.5 points that has a 25-year amortization period. You expect to sell this building for a net of $14,500,000 (i.e. after selling expense are paid) five years from today.
Question a) What is loan amount and intial investment
Question b) What is monthly loan payment and loan balance after 5 years?
Question c) What is ADS and Net Operating income year 1?

Trending nowThis is a popular solution!
Step by stepSolved in 6 steps with 2 images

- Project 1 requires an original investment of $54,000. The project will yield cash flows of $8,000 per year for nine years. Project 2 has a calculated net present value of $17,300 over a seven-year life. Project 1 could be sold at the end of seven years for a price of $37,000. Use the Present Value of $1 at Compound Interest and the Present Value of an Annuity of $1 at Compound Interest tables shown below. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 5 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 7 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 9 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402…arrow_forwardA machine can be leased for four years at $1000 per month payable at the beginning of each month. Alternatively, it can be purchased for $45,000 and sold for $5000 after four years. Should the machine be purchased or leased if the firm's cost of borrowing is: a. 6.6% compounded monthly? b. 9% compounded monthly? *arrow_forwardYour firm needs to invest in a new delivery truck. The life expectancy of the delivery truck is five years. You can purchase a new delivery truck for an upfront cost of $250 000, or you can lease a truck from the manufacturer for five years for a monthly lease payment of $5 000 (paid at the end of each month). Your firm can borrow at 5% APR with quarterly compounding. What is the present value of lease payments? (Rounded to the nearest dollar)arrow_forward
- A property is expected to have NOI of $100,000 the first year. The NOI is expected to increase by 5 percent per year thereafter. The appraised value of the property is currently $1.25 million and the lender is willing to make a $1,125,000 participation loan with a contract interest rate of 5.5 percent. The loan will be amortized with monthly payments over a 20-year term. In addition to the regular mortgage payments, the lender will receive 50 percent of the NOI in excess of $100,000 each year until the loan is repaid. The lender also will receive 50 percent of any increase in the value of the property. The loan includes a substantial prepayment penalty for repayment before year 5, and the balance of the loan is due in year 10. (If the property has not been sold, the participation will be based on the appraised value of the property.) Assume that the appraiser would estimate the value in year 10 by dividing the NOI for year 11 by an 8 percent capitalization rate. Assume that another…arrow_forwardNet advantage to leasing (NAL) ABC Corp is considering a leasing arrangement to finance some machinery it needs for the next 3 years. The depreciation schedule and salvage value are given below. It can borrow $5,000,000, the purchase price, at 10% and buy the machinery, or it can make 3 equal end-of-year lease payments of $2,100,000 each and lease them. The loan obtained from the bank is a 3-year simple interest loan, with interest paid at the end of the year (the loan will be repaid in full in 3 years). The firm's tax rate is 40%. Annual maintenance costs associated with ownership are estimated at $250,000 (paid at the end of the year), but this cost would be borne by the lessor if it leases. What is the net advantage to leasing (NAL)?arrow_forward(Loan Amortization Problem) Your company is planning to borrow $2,500,000. This will be a six-year, 2 percent per year, annual payment, fully amortized term loan. The first payment will be made one year from today. What fraction of the total annual payment made at the end of year three will represent repayment of principal? [Hint: you need only complete the first three rows of the amortization schedule to answer this question.] Step By Step please, as if writing down the solution on a sheet of paper.arrow_forward
- A $150,000 loan is to be amortized over 6 years, with annual end-of-year payments. Which of these statements is CORRECT? The proportion of interest versus principal repayment would be the same for each of the 7 payments. The annual payments would be larger if the interest rate were lower. If the loan were amortized over 10 years rather than 6 years, and if the interest rate were the same in either case, the first payment would include more dollars of interest under the 6-year amortization plan. The proportion of each payment that represents interest as opposed to repayment of principal would be higher if the interest rate were lower. The proportion of each payment that represents interest versus repayment of principal would be higher if the interest rate were higher.arrow_forward1. An amortized loan of P250,000 with an interest rate of 9% will be paid monthly for 3 years. Find the monthly amortization. A high-end laptop computer was bought at an amortized loan of P100,000 with 12% annual interest for 24 months. Find the semi- annually amortization and construct an amortization schedule.arrow_forward13. 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% ?arrow_forward
- Prepare an amortization schedule for a four-year loan of $40000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. Rework it by assuming that the loan agreement calls for a principal reduction of $10000 every year instead of equal annual payments. include excel filearrow_forwardSuppose you obtain a five-year lease for a Porsche and negotiate a selling price of $157,000. the annual interest-rate is 8.4%, the residual value is $76,000, and you make a down payment of $5000. Find each of the following. A) the net capitalized cost B) the money factor (round to 4 decimal places) C) the average monthly finance charge (round to the nearest cent) D) the average monthly depreciation (round to the nearest cent) and E) the monthly lease amount (round to the nearest cent)arrow_forwardAssume you have taken out a partially amortizing loan for $1,000,000 that has a term of 7 years, but amortizes over 20 years. Calculate the balloon payment if the interest rate on this loan is 10%arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education





