Answered step by step
Verified Expert Solution
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 $
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started