This math project for business math 1324 is due by midnight and i have no idea how to do it. Please help!

District manager Part 1 Find the following from the students specicicintormation pronded byvou intructor. c. After your annuity contribution what is D. Sabtract isso odvour monthy tarable erois s 6. Based on the common practice of keeping vour rent or mortgage payment at 1/3 of your net walary, what F. Based on your prospective monthiy payment, what is the maximum mortgage you can afford li.e the Part 2 Using a spreadsheet, create fi.e build your own the first two lines of an amortization table uing vour interest rate of 6.3% on a 20 -vear mortgage using the amount found in Part 1 showing the following columns and farmulas: beginning balance, payment amount, amount of interest paid, amount of principal paid, and the ending Video submission for Part 2: 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 your formulas that you buit in your spreadsheet, while you narrate with your explanation. Part 3 For the following questions you may use an amortization table template customized with the same interest rate and 20-year mortgage amount used previously. A. How much of the first payment will go toward paving down the principle? 8. How much interest will be paid at the end of the mortgage? C. How many payments will be made when the principle overtakes the interest? D. If you manage to pay an extra $100 each month, how much interest will you save? E. How many payments will you drop at the end? Video submission for Part 3: 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 used the amortization table template, while you narrate with your explanation. Part 4 Considering what you committed to spend on retirement and a mortgage find the following: A. You've now bought a house and are ready to buy a new vehicle, using no more than 20% of what you have left after your house payment. How much can you afford per month for a vehicle? B. What will you have left after paying your mortgage and auto payment for all other expenses for the month? District manager Part 1 Find the following from the students specicicintormation pronded byvou intructor. c. After your annuity contribution what is D. Sabtract isso odvour monthy tarable erois s 6. Based on the common practice of keeping vour rent or mortgage payment at 1/3 of your net walary, what F. Based on your prospective monthiy payment, what is the maximum mortgage you can afford li.e the Part 2 Using a spreadsheet, create fi.e build your own the first two lines of an amortization table uing vour interest rate of 6.3% on a 20 -vear mortgage using the amount found in Part 1 showing the following columns and farmulas: beginning balance, payment amount, amount of interest paid, amount of principal paid, and the ending Video submission for Part 2: 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 your formulas that you buit in your spreadsheet, while you narrate with your explanation. Part 3 For the following questions you may use an amortization table template customized with the same interest rate and 20-year mortgage amount used previously. A. How much of the first payment will go toward paving down the principle? 8. How much interest will be paid at the end of the mortgage? C. How many payments will be made when the principle overtakes the interest? D. If you manage to pay an extra $100 each month, how much interest will you save? E. How many payments will you drop at the end? Video submission for Part 3: 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 used the amortization table template, while you narrate with your explanation. Part 4 Considering what you committed to spend on retirement and a mortgage find the following: A. You've now bought a house and are ready to buy a new vehicle, using no more than 20% of what you have left after your house payment. How much can you afford per month for a vehicle? B. What will you have left after paying your mortgage and auto payment for all other expenses for the month