You have secured a loan from PNC Bank for two years to build a new business...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $150,000 now and an additional $50,000 in one year. Interest of 6 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 6 percent compounded rate. At the end of the two years, the balance will be converted to a traditional 30-year mortgage at a 4 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 $125,000 now and an additional $25,000 in one year. Interest of 5 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 3.75 percent interest rate. What will you pay as monthly mortgage payments (principal and interest only)? 1) Calculate the monthly payments on both loans 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. 3) What do you need to take into consideration when deciding which loan to pursue? 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 $150,000 now and an additional $50,000 in one year. Interest of 6 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 6 percent compounded rate. At the end of the two years, the balance will be converted to a traditional 30-year mortgage at a 4 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 $125,000 now and an additional $25,000 in one year. Interest of 5 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 3.75 percent interest rate. What will you pay as monthly mortgage payments (principal and interest only)? 1) Calculate the monthly payments on both loans 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. 3) What do you need to take into consideration when deciding which loan to pursue?
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the monthly payments on the loan from PNC Bank we will use the formula for compound interest A P1 rnnt A the future value of the loan P ... View the full answer
Related Book For
Finance Applications and Theory
ISBN: 978-0077861681
3rd edition
Authors: Marcia Cornett, Troy Adair
Posted Date:
Students also viewed these finance questions
-
You have secured a loan from your bank for two years to build your home. The terms of the loan are that you will borrow $200,000 now and an additional $100,000 in one year. Interest of 10 percent APR...
-
You have secured a loan from your bank for two years to build your home. The terms of the loan are that you will borrow $100,000 now and an additional $50,000 in one year. Interest of 9 percent APR...
-
Through a client referral, you have secured a meeting with a prospective customer. Her name is Sharon Jones. By the end of the initial telephone interview, you learned that she owns her own townhouse...
-
Motion of Electrons in a Magnetic Field An electron of mass m and charge -e is moving through a uniform magnetic field B = (B, 0, 0) in vacuum. (Figure 1)At the origin, it has velocity (Uz, Vy, 0),...
-
Sales for the past 12 months at Dalworth Company are given here. a. Use a three month moving average to forecast the sales for the months May through December. b. Use a four-month moving average to...
-
Compare the generic UML class diagram for the conversion process shown in Figure 7.5 with a generic sales and collection diagram, similar to Figure 5.9. Identify the similarities and differences and...
-
On April 1, 2006, US Ultracom issued 7\%, 10-year bonds payable with maturity value of \(\$ 400,000\). The bonds pay interest on March 31 and September 30, and US Ultracom amortizes premium and...
-
Abbott Corporation does not conduct a complete annual physical count of purchased parts and supplies in its principal warehouse but instead uses statistical sampling to estimate the year- end...
-
Hampshire Farms is a locally operated campground and micro-brewery on the west coast ofNewfoundland. For many years it was a family farming operation; it has gradually...
-
Three years ago. Karen Suez and her brother-in-law Reece Jones opened Glgasales Department Store. For the first 2 years, business was good, but the following condensed income statement results for...
-
X-rays of wavelength 2=1.5 are reflected from the (2 2 2) planes of a cubic crystal with unit cell a = 5. Evaluate the Bragg angle, 0, for n=1.
-
The legal environment in which a public accountant in Canada operates is changing. Discuss some of the reasons for the changes.
-
How does the auditor document the assessment of corporate governance?
-
Which of the following is a description of the integrated test facility? a. Simulated data and actual client data are processed with the client's computer program. b. Simulated data are processed on...
-
Describe regulatory influences on board members and management. What have been the effects of these influences?
-
Which of the following tests of controls do not require use of the computer? a. Compare computer output with source documentation. b. Test data. c. Integrated test facility. d. Parallel simulation.
-
The following figures are found on an income statement: Sales $300 Total Expenses $240 Net Income $60 After the income statement has been converted to common-size form, which of the following...
-
DEPARTMENT DATA EMPLOYEE DATA EmployeeNumber FirstName Mary Rosalie Richard George Alan 3 4 5 7 8 9 855555ES 12 13 14 15 16 17 Create the database tables in SQL or ACCESS: 18 19 20 PROJECT DATA Ken...
-
You invested $2,000 in the stock market one year ago. Today, the investment is valued at $1,500. What return did you earn? What return would you need to get next year to break even overall?
-
Using the information in the table, compute the required return for each company using both CAPM and the constant growth model. Compare and discuss the results. Assume that the market portfolio will...
-
A 2.75 percent TIPS has an original reference CPI of 185.4. If the current CPI is 210.7, what is the current interest payment and par value of the TIPS?
-
The state of stress stress at a critical point on a thin steel shell is shown. Determine if yielding has occurred using the maximum distortion energy theory. The yield stress for the steel is...
-
The state of strain at the point on the bracket has components of \(\epsilon_{x}=350\left(10^{-6} ight), \quad \epsilon_{y}=-860\left(10^{-6} ight)\), \(\gamma_{x y}=250\left(10^{-6} ight)\). Use the...
-
The state of strain at the point on the bracket has components of \(\epsilon_{x}=-130\left(10^{-6} ight), \quad \epsilon_{y}=280\left(10^{-6} ight)\), \(\gamma_{x y}=75\left(10^{-6} ight)\). Use the...
Study smarter with the SolutionInn App