Reference no: EM133633401
Use the Loan Amortization Excel spreadsheet to answer the following questions in the five scenarios.
1. Let's turn to thinking about a car loan. A car loan is repaid (amortized) over a shorter period of time. Now, you are choosing between buying a new or used car. The used car has relatively low mileage and is in good condition. Both vehicles come with good warranties. You can borrow either $15,000 (new) or $5,000 (used) over 3 years at 6.5% interest.?
How much more is the monthly payment for the $15,000 loan than the $5,000 loan? That is, calculate the payment for borrowing $15,000 at 6.5% interest for 3 years then substract the payment for borrowing $5,000.
(Enter dollars and cents as numbers only, no dollar sign or commas.
2. How much more is the total interest for the $15,000 loan than the $5,000 loan? That is, calculate the total interest for borrowing $15,000 at 6.5% interest for 3 years then subtract the total interest for borrowing $5,000.
(Enter dollars and cents as numbers only, no dollar sign or commas.)
3.Will you buy new or used? Explain by comparing benefits and costs. Also discuss from where the funds will come in your zero-based budget when you purchase a car.
4. Your credit history will impact the interest rate that lenders are willing to offer you. If you have a high credit score, you will pay a lower interest rate. If you have a low credit score, you will pay a higher interest rate.
What are your monthly payments and total interest if you borrow $15,000 over 3 years at 13.0% interest because of bad credit?
|
Explore the concept of public perception
: In this discussion, you will explore the concept of public perception and the impact it has on the mental health field.
|
|
Calculate the payback period and profitability index
: Calculate the payback period, profitability index, net present value, and internal rate of return for the new strip mine. Should Bethesda Mining take
|
|
How can a positive credit report help you prosper
: How can a positive credit report help you prosper? How can a negative report weigh you down? What actions can you take to improve your credit history?
|
|
Discuss social influence-persuasion on social psychology
: The topic is about Social Influence and Persuasion on social psychology. I have to explain the concept.
|
|
How much more is the total interest
: How much more is the total interest for the $15,000 loan than the $5,000 loan? That is, calculate the total interest for borrowing $15,000 at 6.5%
|
|
Identify organizations that regulate your nursing license
: Identify the organizations that regulate your nursing license, scope of practice, and certifications. Analyze important aspects and requirements of regulations.
|
|
How much will you need to deposit each month in the college
: Would you accept this deal? Explain why or why not,and indicate any relevant risks - How much will you need to deposit each month in the college savings account
|
|
Emphysema undergoes pulmonary function testing
: A patient with emphysema undergoes pulmonary function testing: When assessing their lung mechanics, you would expect to find
|
|
What is your learning plan with defined action or strategies
: What is your learning plan with defined actions or strategies for the practice improvement for the difference-size blood pressure cuff?
|