Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller financing—that is, a loan from the current owners of the agency. The loan will be for $2 million financed at an APR of 7 percent compounded monthly. This loan will be paid off over 5 years with end-ofmonth payments, along with a $500,000 balloon payment at the end of year 5. That is, the $2 million loan will be paid off with monthly payments, and there will also be a final payment of $500,000 at the end of the final month. How much will the monthly payments be

Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller financing—that is, a loan from the current owners of the agency. The loan will be for $2 million financed at an APR of 7 percent compounded monthly. This loan will be paid off over 5 years with end-ofmonth payments, along with a $500,000 balloon payment at the end of year 5. That is, the $2 million loan will be paid off with monthly payments, and there will also be a final payment of $500,000 at the end of the final month. How much will the monthly payments be

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter19: Lease And Intermediate-term Financing

Section: Chapter Questions

Problem 14P

See similar textbooks

Similar questions

Roger Sterling has decided to buy an ad agency and is going to finance the purchase with seller financing-that is, a loan from the current owners of the agency. The loan will be for 2,100,000 financed at an APR of 8 percent compounded monthly. This loan will be paid off over 7 years with end o month payments, along with a 600,000 balloon payment at the end of year 7. That is, the 2.1 million loan will be paid off with monthly payments, and there will also be a final payment of 600,000 at the end of the final month. How much will the monthly payments be?
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)
A buyer is considering purchasing a 10-acre parcel in Peoria, Arizona for economic development. The parcel has a sales price of $720,000. The buyer agrees with the seller for purchasing the property with 15% down up front and paying off the balance in 12-months. If a bank is willing to provide 3% annual interest, compounded monthly, how much should the monthly deposit be into that account to pay off the desired balance to the seller?
Lola's Furniture is offering a "houseful of furniture" for $9,999. Furthermore, if you make a down payment of $999 you can wait for 1½ years to pay the $9,000 balance. If Lola's Furniture immediately sells the $9,000 receivable contract to the Barzini Finance Group at a discount rate of 18% compounded quarterly, how much money will Lola's actually receive for the "houseful of furniture"?
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.
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.25 million. The property is projected to produce a first year NOI of $125,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Required: a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period?
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.25 million. The property is projected to produce a first year NOI of $125,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Excel calculation would be appreciated! a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period?
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.50 million. The property is projected to produce a first year NOI of $140,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Required: a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period? Complete this question by entering your answers in the tabs below. Required A Required B What will the balloon payment be at the end of the fifth year? (Do not round…
Cooley Landscaping needs to borrow $25000 for a new front-end dirt loader. The bank is willing to loan the money at 8% interest for the next 6 years with annual, semiannual, quarterly, monthly or payments. What are the different payments that Cooley Landscaping could choose for these different payment plans?
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $2.5 million. The property is projected to produce a first year NOI of $200,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly, but will increase by 10% at the beginning of each year for five years. The contract rate of interest on the loan is 12%. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. What will the balloon payment be at the end of the fifth year (rounded to the nearest dollar)? Question 11 options:
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $2.5 million. The property is projected to produce a first year NOI of $200,000. The lender will allow only up to an 80 percent loan on the property and requires aDCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 10 percent at the beginning of each year for five years. The contract rate of interest on the loan is 12 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period.a. What will the balloon payment be at the end of the fifth year?b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period?
An executive is looking to buy a Bugatti for $1.9 million. The car dealer can offer financing at a 4.9% rate over 5 years. If $900,000 is put down towards the purchase and the financing terms accepted, what will the monthly payment for the loan be? and what formula would i use to calculate this in excel?