Qn: 64 Please show the formula if you are using excel, or steps for manual solution, so that I can understand the solution

You will graduate in the near future and will begin working. You negotiated the offer and will be making $40,000 per year. After taxes and deductions, you will bring home 70% of that $40,000 ($28,000) or 2,333 per month. This is what you will have to live on each month. Rent, utilities, food, etc. must come out of the $2,333.00 each month. These are living expenses. But you also have debt. See the table below. ITEM PURPOSE DEBT BALANCE INTEREST RATE MONTHLY PAYMENT MONTHS TILL PAID OFF TOTAL PAYMENTS & INTEREST SCHOOL $22,000 $253.00 STUDENT LOAN 120 MISC. CREDIT CARD $3000 18.9 $120 CLOTHES $1500 12.9 $75 STORE CARD TOTAL IN THE ABOVE TABLE, FILL IN TOTAL PAYMENTS & INTEREST FOR COLUMN G AND YOUR TOTALS FOR COLUMNS C, E AND G What percent is the Column E total of your $2,333 take home pay?------- You will graduate in the near future and will begin working. You negotiated the offer and will be making $40,000 per year. After taxes and deductions, you will bring home 70% of that $40,000 ($28,000) or 2,333 per month. This is what you will have to live on each month. Rent, utilities, food, etc. must come out of the $2,333.00 each month. These are living expenses. But you also have debt. See the table below. ITEM PURPOSE DEBT BALANCE INTEREST RATE MONTHLY PAYMENT MONTHS TILL PAID OFF TOTAL PAYMENTS & INTEREST SCHOOL $22,000 $253.00 STUDENT LOAN 120 MISC. CREDIT CARD $3000 18.9 $120 CLOTHES $1500 12.9 $75 STORE CARD TOTAL IN THE ABOVE TABLE, FILL IN TOTAL PAYMENTS & INTEREST FOR COLUMN G AND YOUR TOTALS FOR COLUMNS C, E AND G What percent is the Column E total of your $2,333 take home pay