Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I don't really get the instruction, can someone help me with this You are planning to purchase a car that costs $20.000. You want to

image text in transcribed

I don't really get the instruction, can someone help me with this

You are planning to purchase a car that costs $20.000. You want to shop around and compare different loan rates and terms before you make a decision. Now you'll want to use a Table to compute your total interest and principal so they can be compared. Loan Amount -20000 Annual Interest Rate see table Term of Loan in Years 5 Total number of month 60 Step 1. In cell D64 enter:=PMT(C64/12,$E$60,$E$57) Watch $ signs. Copy by dragging the cursor. Excel function: PMT = (rate, term, principal) Divide the interest rate by 12 to convert to monthly Total Interest Interest +Principal PMT @ 2% = 351 Int+ Prin = 21,033 With Various Interest Rates: Rate PMT 2.0% 351 3.0% 40% 5.0% 6.0% 7.0% 8.0% Step 2. Total Interest Column: In E64 enter: =D64*60+$E$57 and copy down. Step 3. Total amount paid = Interest - Principal: In G64 enter: =E64-SE$57 and copy down. Total Interest Interest + Principal With Various Terms (Years): Monthly Years PMT 1 3 S 7 9 11 12 Inputs: rate 0.12 loan prin-20000 term in yrs 12 PMT = (rate, term, principal) = (.06/12 yrs *12.-20000) Step 1. In cell D77 enter: =PMT($K$78/12,$K$80*12,$K$79) and copy down. Step 2. In E77 enter: =D77*C77*$K$80+$K$79 Step 3. In G77 enter: = E77-SK$79 check numbers: 12 yrs: pmt=5263, Int+Prin=$37,826 Step 4. Copy down cells in table What is your choice of loan rates and terms

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Tools for Business Decision Making

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

6th edition

978-1118096895

Students also viewed these Finance questions