A lender has outlined key terms for a 4-year annuity balloon mortgage at a fixed interest rate including the credit margin of 5.50%, with a maximum loan-to-value (LTV) ratio of 55% amortised over 20 years. The property is in a good but not prime location. It is fully leased to a range of mainly good credit rated tenants. Leases have between 3 years and 7 years remaining and all have internal repairing only clauses with annual escalation to CPI. Year 0 Year 1 Year 2 Year 3 Year 4 Market Value -25.000 Transaction costs @ 6.80% -1.700 Purchase cost -26.700 Net Income Capex @ 10.00% Sale incl'g costs 2.250 2.340 2.434 2.531 -0.225 -0.234 -0.243 -0.253 29.246 Net Cash Flows Figures shown in £millions. -26.700 2.025 2.106 2.190 31.524 Set out the line by line After Debt Cash Flow, based on the details above and whatever further reasonable and fully justified assumptions you feel are necessary. The borrower only invests in property that can achieve an after debt annual return of 14.00% or above and an average forecasted cash-on-cash of 7.50%. Show your detailed calculations and comment on whether this project is capable of meeting these criteria?

A lender has outlined key terms for a 4-year annuity balloon mortgage at a fixed interest rate including the credit margin of 5.50%, with a maximum loan-to-value (LTV) ratio of 55% amortised over 20 years. The property is in a good but not prime location. It is fully leased to a range of mainly good credit rated tenants. Leases have between 3 years and 7 years remaining and all have internal repairing only clauses with annual escalation to CPI. Year 0 Year 1 Year 2 Year 3 Year 4 Market Value -25.000 Transaction costs @ 6.80% -1.700 Purchase cost -26.700 Net Income Capex @ 10.00% Sale incl'g costs 2.250 2.340 2.434 2.531 -0.225 -0.234 -0.243 -0.253 29.246 Net Cash Flows Figures shown in £millions. -26.700 2.025 2.106 2.190 31.524 Set out the line by line After Debt Cash Flow, based on the details above and whatever further reasonable and fully justified assumptions you feel are necessary. The borrower only invests in property that can achieve an after debt annual return of 14.00% or above and an average forecasted cash-on-cash of 7.50%. Show your detailed calculations and comment on whether this project is capable of meeting these criteria?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A property is available for sale that could normally be financed with a fully amortizing $82,000 loan at a 10 percent rate with monthly payments over a 25-year term. Payments would be $745.13 per month. The builder is offering buyers a mortgage that reduces the payments by 50 percent for the first year and 25 percent for the second year. After the second year, regular monthly payments of $745.13 would be made for the remainder of the loan term. Required: a. How much would you expect the builder to have to give the bank to buy down the payments as indicated? b. Would you recommend the property be purchased if it was selling for $5,000 more than similar properties that do not have the buydown available? Complete this question by entering your answers in the tabs below. Required A Required B How much would you expect the builder to have to give the bank to buy down the payments as indicated? Note: Do not round intermediate calculations. Round your final answer to 2 decimal places. Down…
Consider the following. Two mortgages are available for $500,000.00. Both are paid monthly, compounded quarterly have terms of 5 years and are amortized over 25 years. One has an interest rate of 3% however prohibits any prepayment, the other has an interest rate of 3.1% and allows for prepayment of 10% of the balance per year. If the borrower expects to make a lump sum payment at the end of each year of $400.00 which mortgage costs the least interest by the end of the term?
Of the bank approves a mortgage of 240,000 for 30 years and at a rate of 6% what will the the annnual mortgage payment
A builder is offering $137,381 loans for his properties at 9 percent for 25 years. Monthly payments are based on current market rates of 9.5 percent and are to be fully amortized over 25 years. The property would normally sell for $150,000 without any special financing. Required: a. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan? Assume that the buyer would have the loan for the entire term of 25 years. Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.) b. At what price should the builder sell the properties to earn, in effect, the market rate of interest on the loan if the property is resold after 10 years and the loan repaid? Do not round intermediate calculations. Round your final answer to the nearest whole dollar amount.)
Please provide your complete solutions to the given problems. You may use MS Excel for your solutions. 1. A loan is to be amortized for 4 years through equal payments of PhP48,532.49 at the end of every 6- month period. If the loan earns interest at 7% compounded semi-annually, create an amortization schedule and find: a. the present value of the loan b. the outstanding principal after 3 years c. the amount of principal already paid after 3 years (sum of the principal repayment column for the first 3 years) d. the total interest paid on this loan (sum of the interest column)
A borrower is interested in comparing the monthly payments on four otherwise equivalent 30 year FRMs. All of the loans are for $300,000 and have a 5.0% interest rate. Rank the loans in size order of their monthly payments from smallest to largest: 1) Fully amortizing ($0 balance remaining at the end of the loan term) 2) Interest-Only ($300,000 balance remaining at the end of the loan term) 3) Partial Amortization ($200,000 balance remaining at the end of the loan term) 4) Negative Amortization ($400,000 balance remaining at the end of the loan term) a) 1, 2, 3, 4 b) 4, 3, 2, 1 c) 4, 2, 3, 1 d) 1, 3, 2, 4
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
After two years in business, the owners have saved (have a surplus of) $123,750.00. They must decide if they will invest in property or investment bonds. If they invest in a property and a vehicle, the total cost will be $445,500,00, of which $123,750.00 will be required as a down payment. The fixed interest rate on the mortgaged amount is 5.40% compounded semi-annually for a term of 13 years. 5. What is the size of the semi-annual payments required to settle this mortgage? 6. What is the size of the final payment? 7. How long would it take (in months) to settle this loan with regular monthly payments of exactly $2000 instead of the PMT value calculated in Part 5?
An interest-only mortgage is made for $94,000 at 6 percent interest for 10 years. The lender and borrower agree that monthly payments will be constant and will require no loan amortization. Required: a. What will the monthly payments be? b. What will be the loan balance after five years? c. If the loan is repaid after five years, what will be the yield to the lender? d. Instead of being repaid after five years, what will be the yield if the loan is repaid after 10 years?
The price of a condominium is $187,000. The bank requires a 5% down payment and one point at the time of closing. The cost of the condominium is financed with a 30-year fixed-rate mortgage at 6.5%. Use the following formula to determine the regular payment amount. Complete parts (a) through (e) below. PMT = a. Find the required down payment. $9350 b. Find the amount of the mortgage. $177650 c. How much must be paid for the one point at closing? $1776 (Round to the nearest dollar as needed.) d. Find the monthly payment (excluding escrowed taxes and insurance). More Enter your answer in each of the answer boxes. 11:12 PM O Type here to search 81°F Mostly cloudy 22 99+ 6/30/2021 DELL F3 F4 FS F6 F7 F8 F9 F10 F11 F12 PrtScr Insert Delete కలnn Home Num $4 %24 & Backspace 8. R T K Enter (凸)
A mortgage for a condominium had a principal balance of $48,400 that had to be amortized over the remaining period of 5 years. The interest rate was fixed at 4.32% compounded semi-annually and payments were made monthly. a. Calculate the size of the payments. $0 Round up to the next whole number b. If the monthly payments were set at $998, by how much would the time period of the mortgage shorten? 0 year(s) c. If the monthly payments were set at $998, calculate the size of the final payment. Round to the nearest cent 0 months $0.00
A property is available for sale that could be financed with a fully amortizing $250,000 loan at 8% with a monthly payment over 30 years. The builder is offering buyers a mortgage that reduces the payment by 20% for first and second year. After the second year, regular payment would be made for the remainder of the loan term. What is the first-year monthly payment for buyer? 1467.53 1657.32 1723.56

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

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 Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS