Financial Error Analysis | Instant Homework Solutions

For this assignment, you will analyze three questions that have been solved by a student. Each example has one error in the solutions. Copy and paste the questions into the discussion board and write a note to the student of what the error is for each example. When correcting each student, be specific as to what was wrong for each case. Example 1: Complete the first month’s charges and find the balance for Month 2. The APR is 15.99% with a minimum payment of 5%. The carry-over balance is $500. Student Answer: Month Carry-Over Balance Finance Charge New Balance Minimum Payment 1 $500 $6.66 $506.66 $25.33 2 $474.67 XXXXXXXX XXXXXXX XXXXXXXXX Example 2: What exact excel formula is needed to find the monthly payment for a house that costs $90,000? The APR is 4.5% for a 30-year loan. Student Answer: =PMT(4.5/12,30*12,-90000) Example 3: Using Excel, what formula is needed to find the total loan amount for a new car? You can spend $180 each month on payments and the loan rate is 5.72% for 4 years. Student Answer: =PV(.0572/12,4/12,-180) **MUST PLEASE USE EXCEL FOR ASSIGNMENT**