Please show the excel formulas in the calculation

Todav Januarv 2016. Jacob and Martha Richards have several forms of debt and they are :e all o QUESTIONS (a) What is the monthly payment Jacob and Martha presently pay on the car loan? Prepare the complete amortization table for the car loan in the space indicated below all the questions [8marks] (b) What is the monthly payment Jacob and Martha presently pay on Jacob's college loan. Prepare the amortization table for the College Loan in the space indicated below all the questions. [8 marks] College Loan Monthly Payment (d) Presently what do Jacob and Martha pay in total monthly for their credit card debt, car loan and college loan? [4 marks] \begin{tabular}{|l|l|} \hline Credit Card, Car Loan \& College Loan Monthly Payment \\ \hline Disposable Income Remaining after this payment & \\ \hline \end{tabular} (e ) Presently what do Jacob and Martha pay monthly for their credit card debt, car loan and college loan and house mortgage? [4 marks] (f) What would be Jacob and Martha's monthly payment, if they consolidated ALL their debt INTO the mortgage, then fill out the blanks below. [10 marks] \begin{tabular}{|l|l|} \hline Total debt & \\ \hline Monthly debt payment at 5.9% for 30 years & \\ \hline Difference in monthly payments in (e ) and (f) & \\ \hline Disposable Income Remaining after this payment & \\ \hline \end{tabular} (g) Why is this exercise valuable to Jacob and Martha? [4 marks] Total Marks Workings: College Loan for Jacob's Car Loan MBA started January 2014 Proposed House Mortgage Todav Januarv 2016. Jacob and Martha Richards have several forms of debt and they are :e all o QUESTIONS (a) What is the monthly payment Jacob and Martha presently pay on the car loan? Prepare the complete amortization table for the car loan in the space indicated below all the questions [8marks] (b) What is the monthly payment Jacob and Martha presently pay on Jacob's college loan. Prepare the amortization table for the College Loan in the space indicated below all the questions. [8 marks] College Loan Monthly Payment (d) Presently what do Jacob and Martha pay in total monthly for their credit card debt, car loan and college loan? [4 marks] \begin{tabular}{|l|l|} \hline Credit Card, Car Loan \& College Loan Monthly Payment \\ \hline Disposable Income Remaining after this payment & \\ \hline \end{tabular} (e ) Presently what do Jacob and Martha pay monthly for their credit card debt, car loan and college loan and house mortgage? [4 marks] (f) What would be Jacob and Martha's monthly payment, if they consolidated ALL their debt INTO the mortgage, then fill out the blanks below. [10 marks] \begin{tabular}{|l|l|} \hline Total debt & \\ \hline Monthly debt payment at 5.9% for 30 years & \\ \hline Difference in monthly payments in (e ) and (f) & \\ \hline Disposable Income Remaining after this payment & \\ \hline \end{tabular} (g) Why is this exercise valuable to Jacob and Martha? [4 marks] Total Marks Workings: College Loan for Jacob's Car Loan MBA started January 2014 Proposed House Mortgage