Amanda's current debt consists of three types of loans: a bank card, an auto loan and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Amanda's current debt consists of three types of loans: a bank card, an auto loan and a department store card. She owes a total of $25,000 and her monthly payments sum to $521.77. The amount she owes, the monthly payment and the interest rates appear in the table below: Loan Type Annual Percentage Rate, Loan Amount Monthly (APR) Current Debt Payment 18% Bank Card Auto Loan Department Store Card TOTALS 5.5% 15% $10,000 $12,500 $ 2,500 $25,000 Amanda is having a hard time meeting the monthly payments and is considering consolidating the three loans to reduce her total monthly payments. She has been offered two options. In both cases, she would borrow $25,000 to pay off her existing three loans leaving her with a single loan payment to a loan company. Option A: A $25,000 home equity line of credit based on "7.8% APR annualized over a 10 year term. The loan is amortized at 7.8% with monthly payments of $162.50. This reduces her monthly payments by $359.27. Loan Total Monthly Amount Payment Option B: A $25,000 home equity loan based on "7.8% APR amortized over a 10 year term with monthly payments of $300.68. This reduces her monthly payments by only $221.09. Options Option A Option B $25,000 $162.50 $25,000 $300.68. $203.21 $238.76 $79.80 $521.77 Annual Percentage Rate, APR 7.8% 7.8% I. (15 points) Under option A: After ten years of making monthly payments of $162.50 at 7.8% compounded monthly, what will be her remaining account balance? Use the TVM Solver to find the answer, and round to the nearest cent. N= I= PV= PMT= FV= P/Y C/Y PMT Use your BEGIN END work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option A? How much did she pay in interest, and how much for principal (balance) reduction? c) What type of loan is loan A? Amanda's current debt consists of three types of loans: a bank card, an auto loan and a department store card. She owes a total of $25,000 and her monthly payments sum to $521.77. The amount she owes, the monthly payment and the interest rates appear in the table below: Loan Type Annual Percentage Rate, Loan Amount Monthly (APR) Current Debt Payment 18% Bank Card Auto Loan Department Store Card TOTALS 5.5% 15% $10,000 $12,500 $ 2,500 $25,000 Amanda is having a hard time meeting the monthly payments and is considering consolidating the three loans to reduce her total monthly payments. She has been offered two options. In both cases, she would borrow $25,000 to pay off her existing three loans leaving her with a single loan payment to a loan company. Option A: A $25,000 home equity line of credit based on "7.8% APR annualized over a 10 year term. The loan is amortized at 7.8% with monthly payments of $162.50. This reduces her monthly payments by $359.27. Loan Total Monthly Amount Payment Option B: A $25,000 home equity loan based on "7.8% APR amortized over a 10 year term with monthly payments of $300.68. This reduces her monthly payments by only $221.09. Options Option A Option B $25,000 $162.50 $25,000 $300.68. $203.21 $238.76 $79.80 $521.77 Annual Percentage Rate, APR 7.8% 7.8% I. (15 points) Under option A: After ten years of making monthly payments of $162.50 at 7.8% compounded monthly, what will be her remaining account balance? Use the TVM Solver to find the answer, and round to the nearest cent. N= I= PV= PMT= FV= P/Y C/Y PMT Use your BEGIN END work above to find: a) Balance of the account after 10 years of payments (be careful with how you interpret the cash-flow convention, which tells you how much you owe to the bank) b) How much does Amanda pay to the loan company during the 10 years under Option A? How much did she pay in interest, and how much for principal (balance) reduction? c) What type of loan is loan A?
Expert Answer:
Answer rating: 100% (QA)
Option A Loan Balance and Payments Loan Analysis with TVM Solver We can use the Loan Payment PMT fun... View the full answer
Related Book For
Personal Financial Planning
ISBN: 9780357438480
15th Edition
Authors: Randy Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
If a ij is symmetric and b ij is antisymmetric, prove in general that the product a ij b ij is zero. Verify this result for the specific case by using the symmetric and antisymmetric terms from...
-
What is a slotting allowance?
-
Atmospheric pollution is a problem that has received much attention. Not all pollution, however, is from industrial sources. Volcanic eruptions can be a significant source of air pollution. The...
-
The radius of a toroid is \(R_{\mathrm{t}}=0.10 \mathrm{~m}\), and the windings have a circular cross section. The radius of each winding is \(R_{\mathrm{w}}=10 \mathrm{~mm}\), and the number of...
-
The cost of goods sold computations for Alpha Company and Omega Company are shown below. Instructions (a) Compute inventory turnover and days in inventory for each company. (b) Which company moves...
-
11. SO2Cl2 on reaction with excess of water results into acidic mixture SO2Cl2 + H2O H2SO4 + 2HC1 16 moles of NaOH is required for the complete neutralization of the resultant acidic mixture. The...
-
Eileen Dover announces she plans to become a mime. Her friend, Paul Down, who cannot bear the sight of mimes, offers to pay Eileen Dover $500 if she agrees never to become a mime. Paul Down's promise...
-
The trial balance extracted from the books of Tailor Times Ltd at 31 December 2012 was as follows: You are given the following additional information: (i) The authorised and issued share capital is...
-
The trial balance of Happy Bookkeeper Ltd, as produced by its bookkeeper, includes the following items: You have been given the following information: (i) The sales ledger debit balances total...
-
If we pass a pointer to an array as a function parameter, must we use pointer notation to access the elements of the array?
-
Flyer Ltd started in business on 1 April 2011. Its issued share capital was 200,000 ordinary shares of 1 each and 100,000 5 per cent preference shares of 1 each. The following information is...
-
Explain what you understand by the accounting term capital gearing, showing clearly the benefits of, and the potential problems associated with high gearing. (Scottish Qualifications Authority)
-
Case 1 Imagine you work in an organisation holding a senior position. You recently observe that the female and male colleagues do not sit together at the lunch table for lunch time. They also...
-
Information graphics, also called infographics, are wildly popular, especially in online environments. Why do you think infographics continue to receive so much attention? How could infographics be...
-
List and briefly discuss the five major reasons for borrowing money through a consumer loan. 1. Auto loans: The loan is secured with the auto, meaning that the vehicle serves as collateral for the...
-
Use Worksheet 14.1 to help Paul and Crystal Meyer, whod like to retire in about 20 years. Both have promising careers, and both make good money. As a result, theyre willing to put aside whatever is...
-
Thea Morris, a recent college graduate, has decided to accept a job offer from a nonprofit organization. Shell earn $45,000 a year but will receive no employee health benefits. Thea estimates that...
-
Consider the following time series data. a. Construct a time series plot. What type of pattern exists in the data? b. Show the four-quarter and centered moving average values for this time series. c....
-
Refer to exercise 35. a. Deseasonalize the time series using the adjusted seasonal indexes computed in part (c) of exercise 35. b. Using Minitab or Excel, compute the linear trend regression equation...
-
The following table reports prices and usage quantities for two items in 2009 and 2011. a. Compute price relatives for each item in 2011 using 2009 as the base period. b. Compute an unweighted...
Study smarter with the SolutionInn App