Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is wrong with the function E8? 0.5% E8 vix X fx =PPMT(D$5,1,D$3*D$2,-B$4) B D E G H 1 Input Area Payment Dates & Cumulative

What is wrong with the function E8?image text in transcribed

0.5% E8 vix X fx =PPMT(D$5,1,D$3*D$2,-B$4) B D E G H 1 Input Area Payment Dates & Cumulative Interest 2 Equipment Cost $ 25,000.00 # of Months/Year 12 First Payment Date 9/1/2021 3 Down Payment $ 5,000.00 # of Years in Loan 5 Last Payment Date 10/1/2026 4 Amount of the Loan $ 20,000.00 Loan APR 6.0% Year of Last Payment 5.08 5 Monthly Payment $ 386.66 Monthly Rate 6 Beginning Monthly Principal Ending Cumulative Cumulative 7 Pmt # Balance Payment Interest Paid Reduction Balance Principal Yearly Interest 8 1 $ 20,000.00 $ 386.66 $ 1,200.00 D$3*D$2,-B$4) ! $ 19,713.34 $ D 286.66 9 2 $19,713.34 $ 386.66 $ 1,197.75 $ 286.66 $ 19,426.69 $ 288.09 10 3 $19,426.69 $ 386.66 $ 1,195.36 $ 286.66 $ 19,140.03 $ 289.53 11 4 $19,140.03 $ 386.66 $ 1,192.83 $ 286.66 $ 18,853.38 $ 290.98 12 5 $ 18,853.38 $ 386.66 $ 1,190.15 $ 286.66 $ 18,566.72 $ 292.43 13 6 $18,566.72 $ 386.66 $ 1,187.31 $ 286.66 $ 18,280.06 $ 293.89 14 7 7 $ 18,280.06 $ 386.66 $ 1,184.30 $ 286.66 $ 17,993.41 $ 295.36 15 8 $17,993.41 $ 386.66 $ 1,181.11 $ 286.66 $ 17,706.75 $ 296.84 16 9 Function Arguments ? X 17 10 PPMT 18 11 19 Rate DS5 12 1 0.005 (1,103.81) 20 13 Per 1 1 = 1 1 21 14 Nper DS3 DS2 = 60 22 15 Pv-B$4 1 = -20000 23 16 FV 1 = number = 24 17 = 286.6560306 25 18 Returns the payment on the principal for a given investment based on periodic, constant payments and a 26 19 constant interest rate. 27 20 Rate is the interest rate per period. For example, use 6%/4 for quarterly 28 21 payments at 6% APR. 29 22 30 23 Formula result = S 286.66 31 24 885.71 32 25 Help on this function OK Cancel 33 26 $ 12,833.60 $ 386.66 $ 1,076.51 $ 286.66 $ $ 12,546.94 $ 324.72 34 27 $ 12,546.94 $ 386.66 $ 1,066.85 $ 286.66 $ 12,260.29 $ 326.35 35 28 $ 12,260.29 $ 386.66 $ 1,056.61 $ 286.66 $ 11,973.63 $ 327.98 36 29 $11.973.63 $ 386.66 S 1.045.75 S 286.66 S 11.686.98 $ 329.62 = A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Computer Accounting With QuickBooks Online

Authors: Donna Kay

3rd Edition

1264127278, 9781264127276

More Books

Students also viewed these Accounting questions

Question

=+Part 1 What kind of client could use vernacular in the campaign?

Answered: 1 week ago