Question

please help me create this excel sheet. thank you.

Sheet 1: Name sheet Budget 2020. Create a 2020 Budget for yourself. It should include the following: Income, Total Income, Expenses (can include mortgage, electricity, cable or dish, college (tuition, books), insurance, car payment, food, entertainment, etc), Total Expenses, Net Income (Income minus Expenses). Formulas must be designed that calculate accurately. Formulas to include Sum, Min, Max, Count. Work these formulas into your spreadsheet. Format your spreadsheet using Bold, Fonts, Font size, Underline, Merge and Center, Currency, decimal placement, Centering, indenting, and styles. The more you use the better your score. Show me your knowledge of what you learned through the book and class. Sheet 2: Name sheet Car Payment. Do a Payment Function to buy a vehicle within your budget. This car payment will be included in your Budget 2020 worksheet. Enhance this spreadsheet with formatting. Interest Rate is 3.89% Duration: 60 months

this is all that the teacher provided she would like us to answer in excel.

Answer 1

Sheet 1 : Budget 2020

Sheet 2 : Calculation of car payment

A B. С D E F G H J K L M N 1 1 2 3 4 5 Calculation of Interest & Repayment of Car Loan Amount Repayment Installments Rate of interest Year Monthly Amount Principal Interest Total Install. Repayment Repayment 18,590.00 60 3.89% Balance 6 7 Formula Principal 18590/60 ca 310 11 310 60 370 10 18590.00 18280.00 17970.00 310 59 369 Interest (Balance amount x rate of interest) /12 11 III 310 368 12 IV 17660.00 310 58 57 56 13 V 17350.00 310 14 VI 17040.00 55 310 310 367 366 365 364 363 18280.00 17970.00 17660.00 17350.00 17040.00 16730.00 16420.00 16110.00 15800.00 15490.00 15180.00 15 VII 16730.00 16 VIII 17 IX 362 18 54 53 52 51 50 49 16420.00 16110.00 15800.00 15490.00 15180.00 X 310 310 310 310 310 361 19 XI 360 20 XII 359 14870.00 21 3720 657 4377 22 14 Sheet27 Sheet28 Sheetde Sheet20 Sheet31 Sheet32 Sheet33 Sheet34

Sheet 3: Bar Chart

А B C D E F G H 1 28 K L M N 29 Bar Chart of Budget 2020 30 31 3000 32 33 34 2500 35 36 37 2000 38 39 40 1500 Expenses 41 Income 42 43 1000 44 45 500 46 47 0 1 2 3 4 5 6 7 8 9 10 11 12 48 49 50 51 Expenses 52 Income 53 1457 2295 1477 2314 1506 2361 1753 1532 2363 1560 2384 1589 2400 1620 2425 1649 2447 1684 2466 1715 2510 1788 2525 2503 KI Sheet27 Sheet28 Sheet29 Sheet30 Sheet31 Sheet32 Sheet33 Sheet34

Note: Please give '=' sign before formula mentioned in excel sheet.

Payment for Car calculated for 12 months considering 3.89% rate of interest per anum.

Principal repayment calculated for every month considering 60 months repayment.