Your company is planning to borrow $0.75 million on a 5-year, 14%, annual payment, fully amortized term loan.
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.
What fraction of the payment made at the end of the second year will represent repayment of principal? Do not round intermediate calculations. Round your answer to two decimal places.
________ %

screenshot of spreadsheet attached just for reference. I need the yellow highlighted percentage above

  

File Home Insert Data S X Arial 10 28 B I UD ab Paste C AA A Font Alignment Undo Clipboard B8 fx A B 1 Loan Amortization 2 3 Loan amount 4 Term in years 5 Annual coupon rate 6 7 Calculation of Loan Payment 8 Loan payment = 9 10 Loan Amortization Schedule 11 12 13 2 14 3 15 4 $750,000 5 14.00% $% 90 00 Conditional Formatting Format as Table Number Tables C D E F G Formula #N/A Beginning Balance Payment Interest Principal Ending Balance Sheet1 Z P3 W 3