1. Correct the formula in cell G12, which should divide the remaining principal (cell G11) by the loan amount (cell D6) to find the percentage of remaining principal.
2. Fill the range H12:K12 with the formula in cell G12 to correct the remaining #DIV/0! errors.

New Product Loan Analysis Charge All Full-Room Wireless Charger CHARGEALL $478,000 4.85% 0.40% 5 Year 2 13 24 Year 3 25 36 Year 4 37 48 Loan Conditions Loan amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan Year 5 49 60 Principal and Interest Payments Year 1 - Months 12 Interest Principal Principal remaining $478,000 Remaining %" #DIV/0! Total $0 $0 ($8,988) 1/6/22 $478,000 #DIV/0! $478,000 #DIV/0! $478,000 #DIV/0! $478,000 #DIV/0! New Product Loan Analysis Charge All Full-Room Wireless Charger CHARGEALL $478,000 4.85% 0.40% 5 Year 2 13 24 Year 3 25 36 Year 4 37 48 Loan Conditions Loan amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan Year 5 49 60 Principal and Interest Payments Year 1 - Months 12 Interest Principal Principal remaining $478,000 Remaining %" #DIV/0! Total $0 $0 ($8,988) 1/6/22 $478,000 #DIV/0! $478,000 #DIV/0! $478,000 #DIV/0! $478,000 #DIV/0