Calculate the monthly payments on both loans

Assignment Help Financial Management

Reference no: EM131921394

You have secured a loan from PNC 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 Bank of America 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)?

1) Calculate the monthly payments on both loans (excel)

2) 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. (excel)

3) What do you need to take into consideration when deciding which loan to pursue? (word)

Reference no: EM131921394

Questions Cloud

Motifs and themes of the metamorphosis : How does the setting, the plot, and the narrator's storytelling impact the reader's understanding of the motifs and themes of The Metamorphosis by Franz Kafka?

What is expected return and standard deviation : What is the expected return and standard deviation for the following stock?

Prepare the journal entry to record the contingent liability : The Heinrich Tire Company recalled a tire in its subcompact line in December 2013. Prepare the journal entry to accrue interest on the liability at end of 2014

Type of payment system will dominate in the future : Which segments of the payment markets do you think each type of payment system will dominate in the future? A market segment can be characterized,

Calculate the monthly payments on both loans : Calculate the monthly payments on both loans (excel). What do you need to take into consideration when deciding which loan to pursue? (word).

Prepare purchases and cash budgets for july and august : On July 1, Five Corners Wholesalers had a cash balance of $145,000 and accounts payable of $77,000. Prepare purchases and cash budgets for July and August

Return is often referred to as the yield on investment : The internal rate of return is often referred to as the yield on an investment.

Distinguish between what is truth v what are lies : What message or agenda are each conveying to "followers?" Discuss three (3) themes for each official. (for example economy, environment, guns)

Reflect on personal and professional skills and capabilities : To reflect on personal and professional skills and capabilities within the framework of the FEIT - Engineering and IT take place within the larger context

User Account

All Pages