need this with all graphs done, please and thank you !!!

Instructions: Personal Financial Management Term Project instruction This project purpose is to guide you to plan your personal financial management for your future. Hence, this project is based on a scenario. Let's assume that you are 30 years old. You are a mid-career individual who is working for a large company. You are married with one child. Your current salary is 8,000 USD a month. You receive approximately $32,000 bonus every year. In terms of saving, at the end of 2021, you were able to save $300,000. Your objective is to plan your personal financial management so that you are prepared for your family and retirement. The project consists of 8 parts. You are required to complete all tables in excel format based on your scenario-based future capital, assets, income, expense, debts, and investments. The excel sheets will be provided through Black Board. Due to the excel format, students will need a computer which contains Microsoft Excel to complete this project. In addition, you need to write. at least 1 paragraph explanation for each part explaining your result and decisions. PLEASE NOTE THAT YOU ARE DOING THIS PROJECT BASED ON A SCENERIO, NOT YOUR REAL LIFE, YOU NEED TO BE CREATIVE AND IMAGINATIVE ABOUT WHAT YOU EARN, HOW MUCH YOU SPEND, ETC. The full instruction and excel sheets are attached below: AUTOMOBILELEASEVERSUS PURCHASE ANALYSIS* Item Description LEASE 1 Initial payment: a. Down payment (capital cost reduction): b. Security deposit: 2 Term of lease and loan (years)* 3 Term oflease and loan (months) (item 212 ) 4 Monthlylease payment 5 Total payments over term of lease (item 3 Item 4) 6 Interest rate earned on savings (in decimal form) 7 Opportunity cost of initial payment (item 1 xitem 2x Item 6) 8 Payment/refund for market value adjustment at end of lease ( $0 for closed-end leases) and/or estimated end-of-term charges 9 Total cost of leasing (item 1a+ Item 5+ Item 7+ item 8 ) PURCHASE 10 Purchase price 11 - Down payment 12. Sales tax rate (in decimal form) 13 Sales tax (item 10 x)tem 12) 14 Monthly loan payment (Terms: 0 months. December 7, 2022 Amount BALANCE SHEET 3 Name(s) 4 For the 7. Income. 8 Wages and salaries 109 \begin{tabular}{|l|l|} \hline Name: & 5 \\ \hline Name: & \\ \hline Name: & \\ \hline & \\ \hline interest received & \\ \hline Dividendsreceived & \\ \hline Rents received & \\ \hline Sale of securities & \\ \hline Other & \\ \hline \end{tabular} 11 Selfemployment income 12. Bonuses and commissions 13. investment income 14 15 \begin{tabular}{|l|l|} \hline 16 & \\ \hline 18 & Densons and an \\ \hline 19 & Other income \\ \hline \end{tabular} (i) Total income $5 22 Housing 23 24 25 26 27 28 lood Cable TV and other 29 oroceries 30 Tranaportation Dining out 31 Autoloan payments 12 License plates, fees, itc. 33 Medical Cas, oli, repairs, tires, maintenance 34 Healthy major medical, diabilityinaurance 35 (pavroll oeductiont or not provided by employed) 36 Clothing. Doctof, dentim, houstal, eredicines 37 insurance Clothes, thoes and accetioner 18 Homeowner i (if not covered by mortrafe payment) HOME AFFORDABILITY ANALYSIS* Name Item Description Amount 1 Amount of annual income 2 Monthly income (item 1+12 ) 3 Lender's alfordability ratio (in decimal form) 4 Maximum monthly mortgage payment (Pim) (item 2 item 3 ) 5 Estimated monthly property tax and homeowner's insurance payment 6 Maximum monthly loan payment (item 4 -item 5) 7 Approximate average interest rate on loan 8 Plannedloan maturity (years) 9 Mortgage payment per $10,000 (using item 7 and ltem 8 and Table of Monthly Mortgage Payments in Exhibit 5.9) 10 Maximum loan based on monthly income ($10,000xitem6+1tem9) 11 Funds avallable for making a down payment and paying closing costs $5 12 Funds available for making a down payment (brem 11.67 ) 13. Maximum purchase price based on available monthly income (item 10+item 12) 14 Minimum acceptable down payment (in decimal form) 15 Maximum purchase price based on down pavment (Hiem 12 + ttem 14) 16 Masimum home purchase price (tower ofttem 13 and item 15) DETERMINING AMOUNT OFINVESTMENT CAPITAL 3 Financial goal: 4 7 1. Targeted Financial Goal (see Note 1) 8 2. Projected Average Return on Investments 9 A. Finding a Lump Sum Investment: \begin{tabular}{|l|} \hline$ \\ \hline \end{tabular} MONTHLY CONSUMER LOAN PAYMENTS \& DEBT SAFETY RATIO Name DatedDecember7,2022 \begin{tabular}{|l|l|l|} \hline \hline 6 & & \\ \hline 7 & & \\ \hline 8 & Type of Loan & \\ \hline 9 & - Auto and Personal & \\ \hline 10 & & 1. \\ \hline 11 & & 2. \\ \hline 12 & - Education loans & 3. \\ \hline 13 & & 1. \\ \hline 14 & - Overdraft Protection Uine & 1. \\ \hline 15 & - Personal line of credit & \\ \hline 16 & - Credit Cards: & 1. \\ \hline 17 & & 2. \\ \hline 18 & & 3. \\ \hline 19 & & 4. \\ \hline 20 & - Home Equity Line & 1. \\ \hline 21 & & \\ \hline \end{tabular} 21.TOTALMONTHLYPAYMENTS$ 23 *Note: List only thoseloans that require regular monthly payments. - Changes needed to reach a new debt safety ratio. 1. New (Target) debt safety ratio: 7. Ac current take home pay of total monthly paymentsmust equal: Total monthly take-home pay Target debt safety ratio*" 5$NewManthlyPayments:0.000=5 OR 3. With current monthly pavments of total takehome pay must racal: New(target)debtsafetyretioTotalmonthlypayments1000.000$100=5: Instructions: Personal Financial Management Term Project instruction This project purpose is to guide you to plan your personal financial management for your future. Hence, this project is based on a scenario. Let's assume that you are 30 years old. You are a mid-career individual who is working for a large company. You are married with one child. Your current salary is 8,000 USD a month. You receive approximately $32,000 bonus every year. In terms of saving, at the end of 2021, you were able to save $300,000. Your objective is to plan your personal financial management so that you are prepared for your family and retirement. The project consists of 8 parts. You are required to complete all tables in excel format based on your scenario-based future capital, assets, income, expense, debts, and investments. The excel sheets will be provided through Black Board. Due to the excel format, students will need a computer which contains Microsoft Excel to complete this project. In addition, you need to write. at least 1 paragraph explanation for each part explaining your result and decisions. PLEASE NOTE THAT YOU ARE DOING THIS PROJECT BASED ON A SCENERIO, NOT YOUR REAL LIFE, YOU NEED TO BE CREATIVE AND IMAGINATIVE ABOUT WHAT YOU EARN, HOW MUCH YOU SPEND, ETC. The full instruction and excel sheets are attached below: AUTOMOBILELEASEVERSUS PURCHASE ANALYSIS* Item Description LEASE 1 Initial payment: a. Down payment (capital cost reduction): b. Security deposit: 2 Term of lease and loan (years)* 3 Term oflease and loan (months) (item 212 ) 4 Monthlylease payment 5 Total payments over term of lease (item 3 Item 4) 6 Interest rate earned on savings (in decimal form) 7 Opportunity cost of initial payment (item 1 xitem 2x Item 6) 8 Payment/refund for market value adjustment at end of lease ( $0 for closed-end leases) and/or estimated end-of-term charges 9 Total cost of leasing (item 1a+ Item 5+ Item 7+ item 8 ) PURCHASE 10 Purchase price 11 - Down payment 12. Sales tax rate (in decimal form) 13 Sales tax (item 10 x)tem 12) 14 Monthly loan payment (Terms: 0 months. December 7, 2022 Amount BALANCE SHEET 3 Name(s) 4 For the 7. Income. 8 Wages and salaries 109 \begin{tabular}{|l|l|} \hline Name: & 5 \\ \hline Name: & \\ \hline Name: & \\ \hline & \\ \hline interest received & \\ \hline Dividendsreceived & \\ \hline Rents received & \\ \hline Sale of securities & \\ \hline Other & \\ \hline \end{tabular} 11 Selfemployment income 12. Bonuses and commissions 13. investment income 14 15 \begin{tabular}{|l|l|} \hline 16 & \\ \hline 18 & Densons and an \\ \hline 19 & Other income \\ \hline \end{tabular} (i) Total income $5 22 Housing 23 24 25 26 27 28 lood Cable TV and other 29 oroceries 30 Tranaportation Dining out 31 Autoloan payments 12 License plates, fees, itc. 33 Medical Cas, oli, repairs, tires, maintenance 34 Healthy major medical, diabilityinaurance 35 (pavroll oeductiont or not provided by employed) 36 Clothing. Doctof, dentim, houstal, eredicines 37 insurance Clothes, thoes and accetioner 18 Homeowner i (if not covered by mortrafe payment) HOME AFFORDABILITY ANALYSIS* Name Item Description Amount 1 Amount of annual income 2 Monthly income (item 1+12 ) 3 Lender's alfordability ratio (in decimal form) 4 Maximum monthly mortgage payment (Pim) (item 2 item 3 ) 5 Estimated monthly property tax and homeowner's insurance payment 6 Maximum monthly loan payment (item 4 -item 5) 7 Approximate average interest rate on loan 8 Plannedloan maturity (years) 9 Mortgage payment per $10,000 (using item 7 and ltem 8 and Table of Monthly Mortgage Payments in Exhibit 5.9) 10 Maximum loan based on monthly income ($10,000xitem6+1tem9) 11 Funds avallable for making a down payment and paying closing costs $5 12 Funds available for making a down payment (brem 11.67 ) 13. Maximum purchase price based on available monthly income (item 10+item 12) 14 Minimum acceptable down payment (in decimal form) 15 Maximum purchase price based on down pavment (Hiem 12 + ttem 14) 16 Masimum home purchase price (tower ofttem 13 and item 15) DETERMINING AMOUNT OFINVESTMENT CAPITAL 3 Financial goal: 4 7 1. Targeted Financial Goal (see Note 1) 8 2. Projected Average Return on Investments 9 A. Finding a Lump Sum Investment: \begin{tabular}{|l|} \hline$ \\ \hline \end{tabular} MONTHLY CONSUMER LOAN PAYMENTS \& DEBT SAFETY RATIO Name DatedDecember7,2022 \begin{tabular}{|l|l|l|} \hline \hline 6 & & \\ \hline 7 & & \\ \hline 8 & Type of Loan & \\ \hline 9 & - Auto and Personal & \\ \hline 10 & & 1. \\ \hline 11 & & 2. \\ \hline 12 & - Education loans & 3. \\ \hline 13 & & 1. \\ \hline 14 & - Overdraft Protection Uine & 1. \\ \hline 15 & - Personal line of credit & \\ \hline 16 & - Credit Cards: & 1. \\ \hline 17 & & 2. \\ \hline 18 & & 3. \\ \hline 19 & & 4. \\ \hline 20 & - Home Equity Line & 1. \\ \hline 21 & & \\ \hline \end{tabular} 21.TOTALMONTHLYPAYMENTS$ 23 *Note: List only thoseloans that require regular monthly payments. - Changes needed to reach a new debt safety ratio. 1. New (Target) debt safety ratio: 7. Ac current take home pay of total monthly paymentsmust equal: Total monthly take-home pay Target debt safety ratio*" 5$NewManthlyPayments:0.000=5 OR 3. With current monthly pavments of total takehome pay must racal: New(target)debtsafetyretioTotalmonthlypayments1000.000$100=5: