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),...
-
What are the primary sources of information about the creditworthiness of credit applicants?
-
When implementing a packaged Enterprise Resource Planning (ERP) system, many companies report that the module they first install is Financial Accounting. Among the measures used to gauge the...
-
Suppose a share of stock sells for \($70.\) The risk-free rate is 5 percent, and the stock price in one year will be either \($80\) or \($90\). a. What is the value of a call option with an \($80\)...
-
a. Assume that Caro-Life wants to maximize the average sales potential of its ten offices. Where should it locate offices and what is the population and geographic area associated with each office?...
-
Please include all work and formulas used. Thanks!. Question 2 Tresla Corporation is experiencing rapid growth. Dividends are expected to double in each of the next two years, grow at 20% per year...
-
1. Which process should VBB choose to produce?? 2. How much would VBP be willing to pay for the testing that is currently offered, for each batch?? 3. Would we be considered a perfect test, at twice...
-
Question 2 In a ro binomial distribution 1=10 and P= 0.35. find The probabilities , the following events : Round final answer to 3 decimal places. ) a . x = 2 Probability b. x = 2 ( the probability...
-
What is the business revenue?
-
Your CEO has asked you to lead a cross-functional management team with the goal of recommending 5 key strategic initiatives to be implemented simultaneously over the next five years. He asks you to...
-
The median household income (adjusted for inflation) in Seattle grew from $42,948 in 1990 to $45,736 in 2000. If it continues to grow exponentially at the same rate, when will median income exceed...
-
Find the area bounded by the graphs of the indicated equations over the given interval. y= -4x+16; y = 21; - 1x2 The area is square units. (Type an integer or decimal rounded to three decimal places...
-
Given the following information regarding an income producing property, determine the NPV using levered cash flows in your analysis: required equity investment: $240,000; expected NOI for each of the...
-
Slow Roll Drum Co. is evaluating the extension of credit to a new group of customers. Although these customers will provide $180,000 in additional credit sales, 12 percent are likely to be...
-
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?
-
\(-\frac{3}{7}\) Identify each number as a natural number, an integer, a rational number, or a real number.
-
\(\sqrt{19}\) Identify each number as a natural number, an integer, a rational number, or a real number.
-
13 Identify each number as a natural number, an integer, a rational number, or a real number.
Study smarter with the SolutionInn App