salary is 65,000 and loan is 40,000

already have it done just wanna double check my work.

3. After your annuity contribution is subtracted, the amount remaining becomes your monthly taxable gross salary. What is your monthly taxable gross salary? 4. Subtract 15% of your monthly taxable gross salary for taxes, insurance etc. to find your monthly net salary. What is your monthly net salary? 5. Using your monthly net salary, you want to get started paying on your student loans, which total With an interest rate of 3.5%, you choose to take 20 years to pay them off. What is your minimum required pmt? 6. When you have made the last payment, how much interest was paid on the original amt of the loan? Part B: Using a spreadsheet, create (i.e. build your own) at least the first 2-3 lines of an amortization table (showing payments 1 \& 2), using 3.5\% APR interest, and the minimum payment from above (E from Part 1). Use the format below, or one similar. ( 6 points) example for Excel Payment \# Payment amount Interest portion Principle portion Principle Balance 0 (loan amt) Part C: For the following, you may either use expand the amortization table from Part 2, or use the template from class for the specified time frame found for E of Part 1 for the number of years. (6 points each) 7. How much of the first payment will go towards paying down the principle? 8. How many payments will be made before the principle becomes greater than the interest? 9. You feel your salary will allow you to double the payment, the extra payment amount will be applied to the principle, how much sooner will you pay it off by doing so (how many years)? 10. How much interest will you save by doubling the payment and paying the loan off early? Video submission for Part B and C: Create a short video (3 minutes or less) where you explain the process used in arriving at your conclusions. In your video, be sure to share your screen and clearly show how you created the amortization table along with how you used it or the template, while you narrate with your explanation. (6 points) Part D: Answer the following using your monthly net salary from Part A \#5. (6 points each) 11. Your rent can be no more than 25% of your monthly net, what is the maximum you can spend on rent? 12. Using no more than 20% of what you have left after your rent and loan payment. How much can you afford per month for a vehicle payment? 13. What will you have left from you net salary, after paying your loan, rent and auto payment, for all other expenses for the month (groceries, utilities, gas, entertainment etc.)