Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How can I autofill the cells until a balance of $ 0 ? Percentage of the Current fixed Minimum $ 30 0 m ' h,

How can I autofill the cells until a balance of $0?
image text in transcribed

Percentage of the Current fixed Minimum $ 30 0 m ' h, I Currency to two decimal places, and Payments per Year as Number to zero decimal places. 5b Below enter Excel formulas with cell references and appropriate built-in Excel functions to calculate the Current Balance, Payment, Balance After Payment, and Interest for each Month. You should continue to fill in the rows until you reach a balance of 0. Note that the Current Balance for Month J is completed for you. Format all cells as Currency with 2 decimal places. Month 1 2 4 5 6 7 8 9 11 i Current Balance $2,200.00 $2,160.15 $2,121.02 $2,082.60 $2,044.88 Payment see note atside $77.00 $75.61 $74.24 $72.89 91.57 Balance After Payment $2,123.00 $2,084.54 $2,046.78 $2,00971 $1,973.31 Interestfow this month. $37.15 $36.48 $35.82 $35.17 $34,53 Ill 5C Use the table from 5b to calculate the Number of Years to Pay Off (based on the number of Months foUnd), Total Amount Paid, and Amount ofTotal Interest Paid. Format the Number of Years to Pay Off as a Number with 2 decimal places and the Total Amount Paid and _Amount of Total Interest Paid as Currency with 2 decimal places. Number of Years to Pay Off Total Amount Paid Amount of Total Interest Paid Note: The amount you pay at the start of the month is the larger of the fixed minimum payment (DIB) and the perCe?tage (D17) of the current balance (column B). You may use =MIN() function to have Excel do this or manually 9Witch formulas in the tables The final payment must riot exceed the balance.

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

Cost And Management Accounting

Authors: Duncan Williamson

1st Edition

0132059231, 978-0132059237

More Books

Students also viewed these Accounting questions