PLEASE HELP ASAP! I WILL UPVOTE!

5. Fill out EAR and EPR by using EFFECT, NOMINAL

6. Fill out range Payment, Interest Component, Principal component, Outstanding Balance, Total paid over life of loan and Total interest paid over life of loand by using VLOOKUP, PMT, IPMT, PPMT

7. Fill out the amortization table

PLEASE ANSWER WITH EXCEL AND SHOW STEPS

\begin{tabular}{|l|l|l|} \hline Frenquency & Number of payment per year & \\ \hline Monthly & 12 \\ \hline Semi-monthly & 24 \\ \hline Bi-weekly & 26 \\ \hline Weekly & 52 \\ \hline \end{tabular} Inputs PrincipalAmortizationPeriod(years)InterestRate(%/year(semi))PaymentFrequencyEAREPR$250,000254% Use Scroll bar to choose a particular period below: Outputs Payment Interest Component Principal Component Outstanding balance Total Paid over Life of Loan Total Interest Paid over Life of Loan Amortization Table Period Payment Balance Owing (BoP) Interest Component Principal Component Balance Owing (EoP) $250,000 \begin{tabular}{|l|l|l|} \hline Frenquency & Number of payment per year & \\ \hline Monthly & 12 \\ \hline Semi-monthly & 24 \\ \hline Bi-weekly & 26 \\ \hline Weekly & 52 \\ \hline \end{tabular} Inputs PrincipalAmortizationPeriod(years)InterestRate(%/year(semi))PaymentFrequencyEAREPR$250,000254% Use Scroll bar to choose a particular period below: Outputs Payment Interest Component Principal Component Outstanding balance Total Paid over Life of Loan Total Interest Paid over Life of Loan Amortization Table Period Payment Balance Owing (BoP) Interest Component Principal Component Balance Owing (EoP) $250,000