Numbers Filo Edit Insert Tablo Organize Format Arrange View Wed Feb 10 11:16 AM Share Window Help Case Assignment 1 Template 2021_Spring .. 125% R View Zoom Collaborate Format Organiza I!! Apple Add Category Q3 Insert Table Chart Text Shape Media Camment Q5 Q6 07 Q8 + 01 Q2 04 09 Sheet Sheet Name Q1 1. Summary of current debt for the family. Based on the information provided in Table 1, if the Halls continue making minimum payments on their outstanding debts, how much money will they have left over for all other experises? What is their total debt amount as of today? Background Inputs on Loans Remaining Loan Term Loan PMT Car Loan 51 $999.00 College Loan 98 $596.00 Credit Card $376.00 Loan Balance Rate (APR) 6.90% 5.20% $9,400 18.99% Duplicate Sheet Delete Sheet Rent Total Monthly expenses Marty's Gross Annual Salary Laura's Gross Annual Salary Income tax rate er-tax Monthly take home pay (Marty) ter-tax Monthly take home pay (Laura) After-tax monthly take home pay total Balance for all other expenses Total Debt Last Vis 4 10 S ety Numbers Filo Edit Insert Tablo Organize Format Arrange View Wed Feb 10 11:16 AM Share Window Help Case Assignment 1 Template 2021_Spring .. 125% R View Zoom Collaborate Format Organiza I!! Apple Add Category Q3 Insert Table Chart Text Shape Media Camment Q5 Q6 07 Q8 + 01 Q2 04 09 Sheet Sheet Name Q1 1. Summary of current debt for the family. Based on the information provided in Table 1, if the Halls continue making minimum payments on their outstanding debts, how much money will they have left over for all other experises? What is their total debt amount as of today? Background Inputs on Loans Remaining Loan Term Loan PMT Car Loan 51 $999.00 College Loan 98 $596.00 Credit Card $376.00 Loan Balance Rate (APR) 6.90% 5.20% $9,400 18.99% Duplicate Sheet Delete Sheet Rent Total Monthly expenses Marty's Gross Annual Salary Laura's Gross Annual Salary Income tax rate er-tax Monthly take home pay (Marty) ter-tax Monthly take home pay (Laura) After-tax monthly take home pay total Balance for all other expenses Total Debt Last Vis 4 10 S ety