Calculate the monthly payments on both loans

Assignment Help Financial Management
Reference no: EM131014715

You have secured a loan from the bank for two years to build a new business location. The terms of the loan are that you will borrow $125,000 now and an additional $25,000 in one year. Interest of 10 percent APR will be charged on the balance monthly. Since no payments will be made during the 2-year loan, the balance will grow at the 10 percent compounded rate. At the end of the two years, the balance will be converted to a traditional 30-year mortgage at a 6 percent interest rate. What will you be paying as monthly mortgage payments (principal and interest only)

You also secured a loan from another bank for two years to build. The terms of the loan are that you will borrow $100,000 now and an additional $50,000 in one year. Interest of 8 percent APR will be charged on the balance monthly. Since no payments will be made during the 2-year loan, the balance will grow. At the end of the two years, the balance will be converted to a traditional 15-year mortgage at a 8 percent interest rate. What will you pay as monthly mortgage payments (principal and interest only)?

Calculate the monthly payments on both loans

Create a spreadsheet with the amortization and payment schedule. Include, Beginning balance, monthly payment, monthly payment towards interest and amount towards principal, total interest paid, and ending balance for both loans.

What do you need to take into consideration when deciding which loan to take.

Reference no: EM131014715

Questions Cloud

Counting income from retirement funds : John just turned 30 and will retire from his job when he turns 63. When John turns 63, he will stop working completely and have an after tax household income (not counting income from retirement funds) of $22,000 per year. He would like to be able to..
What volume of helium do you think you can breathe in : A "pressure cooker" is a device that allows food to be cooked at pressures that are higher than atmospheric pressure. Explain why this device changes how your food is cooked.
Time passes mysterious forces convince : You've already explored the lie of fate taking control of our destiny as we grow older. Now I want to expand your thinking to a related idea: King Mechizedek tells the boy that when we are children, "everything is clear and everything is possible," b..
Calculate the monthly payments on both loans : You have secured a loan from the bank for two years to build a new business location. The terms of the loan are that you will borrow $125,000 now and an additional $25,000 in one year. Calculate the monthly payments on both loans. Create a spreadshee..
Value of the calculated test statistic : a. State an appropriate null hypothesis. b. What is the value of the calculated test statistic (Z)? c. State your conclusion.
Why would company decide not to handle payment processing : Outsourcing of payment system operations is a very popular alternative to accepting payments directly from customers. Why would a company decide not to handle payment processing? Does it really save time and money? What are the potential legal ramifi..
Find value of k : If a line y=3x+6 is tangent to the circle x^2+y^2=9 at point (k,k+1) then find value of k?
Create a t-sql script that returns the student id : Write a T-SQL statement that returns the faculty ID, last name and monthly salary of two faculty members with the two lowest monthly salary values.

Reviews

Write a Review

Financial Management Questions & Answers

  Based on your knowledge of aggregate demand

The global economy in 2011 appears to be headed into a double-dip recession. Based on your knowledge of aggregate demand and aggregate supply, suggest the reasons and causes for the downward tailspin of the economy. Provide support for your response.

  Issue of preferred stock

E-Eyes.com has a new issue of preferred stock it calls 20/20 preferred. The stock will pay a $20 dividend per year, but the first dividend will not be paid until 20 years from today. If you require a return of 9.25 percent on this stock, how much sho..

  Calculated his return on investment

George bought an investment one year ago and just calculated his return on investment. He found that his purchasing power has increased by 15% as a result of his investment. If the inflation over the period was 4%, his _______________.

  Value of six-month european call option with strike price

A futures price is currently 100. At the end of six months it will be either 112 or 90. The risk-free interest rate is 5% per annum. What is the value of a six-month European call option with a strike price of 100?

  Find the periodic payment

Find the periodic payment R required to amortize a loan of P dollars over t years with interest charged at the rate of r% year compounded m times a year.

  What are wilsons profit margin and debt ratio

The Wilson Corporation has the following relationships: Sales/Total assets 2.0x Return on assets (ROA) 4.0% Return on equity (ROE) 6.0% What are Wilson’s profit margin and debt ratio?

  How is it possible for ppp to hold if the ife does not

Comparing PPP and IFE. How is it possible for PPP to hold if IFE does not? How will this spot rate adjust according to PPP if the United Kingdom experiences an inflation rate of 7% while US experiences an inflation rate of 2%?

  Explain the current yield offered by each preferred stock

What is the current yield offered by each preferred stock? Why are the prices of these preferred stocks different even though they both pay the same dividend?

  How much should save each month

Sarah wants to go buy a house in Hawaii 15 years from now. She estimates she'll need $400,000 at that time to make this purchase. She plans to save each month at the end of the month for the next 15 years, and invest it at a rate of 8% a year, compou..

  What is the days sale outstanding

Snider Industries sells on terms of 3/10, net 35. Total sales for the year are $1,869,000. Thirty percent of the customers pay on the 10th day and take discounts; the other 70% pay, on average, 64 days after their purchases. What is the day’s sale ou..

  Dividend growth rate is expected-current stock price

Your company just paid a dividend of $2.00. The dividend growth rate is expected to be 4% for 1 year, 5% the next year, then 6% for the following year, and a constant 7% thereafter. The stock's required return (rs) is 10%. What is the current stock p..

  What is the current stock price

ACME will pay a quarterly dividend per share of $.75 at the end of each of the next 12 quarters. Thereafter, the dividend will grow at a quarterly rate of 1% forever. The appropriate discount rate on the stock is 10%, compounded quarterly. What is th..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd