how to solve in excel

MB fa c 0 E F 0 H N 0 Points B Student Grade 1 1 42 42 Final Assignment GPA Calculations, PMT - Mortgage and Car Payment 1 Save the workbook as First Initial Last Name Student Number GPA Example KiPa 0123456GPA 2 In the documentation worksheet enter your name in cell student number in 15 and the date in cell. Co to the budget Worksheet and follow the instructions found there 4 Go to the GPA Worksheet and follow the instructions found there 5 Go to buying a Car Worksheet and follow the instructions found there Save the workbooks in initial state Student Number GPA, and submit your excellen the Assignment by selecting Browse Computer and Attaching your Excel file. Then Save and Submit Example: Kolo0123450GPA TOTAL = 8: 81 10 11 12 13 14 2) 23 150 150 15 16 12 18 19 20 21 Instructions Documentation Budget GPA Buying a Car Abwe Ry AL 1X Final Assignment A C D Final Assignment 2 GPA Calculations, PMT - Mortgage and Car Payment Student Points Grade 3 4 Author 5 Student Number 6 Date Purpose 1 1 1 To complete the final assignment for BUS207 3 14 Instructions Documentation Budget GPA Buying a Car 100 GON 3 E2 X lo student number 0123456 the down payment is 100 X 456 = $45.800. Use this information to complete the information in cells B3 to 110 and following the instructions D G Carlato Family Budget Student Number Cristofer and Mis Carlate of Windsor, Ontario are using Excel to track their family budget to determine whether they Points Student can afford the monthly loan payments that would come with the purchase of a new vacation home in Italy. The couple Grade is cordering a $420,000 home at a 2.95annual interest rate to be paid back over 30 years. They want to know the Mortgage 5 5 Impact that this mortgage will have on their budget. Their down payment is 100 times the last 3 digits of YOUR student Annual Interest Rate 2 2 number. For example, foe student number 0123456 the down payment is 100 X 456 $45,600. Use this information Interest Rate per Month to complete the information in cells 83 to 110 and following the instructions below 3 in Colt B2 type in your student number Years 2 2 In Cell By use a formula to calculate the amount the couple will borrow from the bank to obtain a mortgage Total Payments 4 In Cell 84 place the annual interest rate. In Cell use a formula to determine the monthly interest rate 10 Monthly Payment In Cell B7 place the number of years that the couple will have to pay for the mortope. in Cell B use a formula to determine the number of payments the couple will make over the wife of the mortgage 11 7 7 in Cell 10 use the PMT function to calculate the monthly mortgage payment. 12 2 2 Copy the formula from Cell C20 to the range 020-N20. 13 3 3 in the range C27:27, use the value in cell B10 as a positive number the decimal places), anturing it is set to holute, for the monthly met payment 14 5 5 In range C29-N29, use a formula to calculate Cristofer and Miastotal monthly expenses 15 42 42 TOTAL 16 17 Income Expenses Item Apr May Aut Sep Oct Ney Documentation Budget GPA Buying a Car Ac 9 9 9 Feb Mar Jun Dec E2 VIX fx student number 0123456 the down payment is 100 X 456 = $45,600. Use this information to complete the information in cells 83 to 10 and following the instructions D F G o 3 3 in the range the value in cell 550 policie number the decimal places, suring it is set to absolute for the monthly more payment 5 5 in range C29.29 use a formula to calculate Cristofer and total monthly expenses. 42 42 TOTAL 17 Income Expenses Income PSHE B Item Cristofer Mia Total Income Food Utilities Phone Insurance Car Travel Mortace Misc Total Expenses Net Income Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec 54,200 $ 4.2005 4,200 $ 4.2005 4,200 54,200 $4,200 5 4,200 $ 4.200 $ 4.2005 4,200 $ 3.500 $ 1,500 2.0005 2.500 1.500 2.000 2.500S 1.500 2.000 2.500 1,500 52.000 2.500 5 5205 250S 4755 4755 4755 4755 3005 1005 500 5 550 S 250S 450 s 165 $ 1655 1655 1505 150 S 150 S 150 1505 1355 135 S 170$ 170 $ 955 955 95 S 955 955 95 S 955 955 95$ 955 955 95 $ 365 3655 3655 3655 365 $ 3655 3655 3655 3655 365 S 365 365 5 5155 5155 515 S 5155 5155 5155 5155 5155 5155 5155 5155 515 5 $ 2.000 S $ - $ $ $ 8505 8505 $ S 3,200 Expenses 5 5505 5505 550 $ 9255 9255 925S 600$ 600$ 600 5 725 S 7255 725 NET 5 - 5 5 5 S 5 5 -- 15 5 5 5 - $ Budget GPA Buying a Car Documentation Aco AI Credo Crew G Tot PA La Con Next . 1 1 AAL 1. semester MOGLO ALEGRE SACHS EOMMODO 7 MES PRIE MATER 2.COM 10 D Student ID Teu Last Name Marin Test 2 Midterm Final Exam Final Average 12 First Name Homework 4 91 Category We EXCO To 16.10 THEO | L Tulcea Total 15 16 17 10240 95 100 77 92 3 95 14 14 21 30 N 2011 570011 22.116.6.23 2330100 34 35 5846-73 Teine N Rai Dale une D A Luk Part super Care Fernandes Anarpreet Budget GPA Buying a Car 75 4 83 61 80 100 34 100 100 B2 1 Documentation Rady BA A 10 12 11 1 1 15 c 0 Interest Rate (per Year) 4,16% RATE per quarter Term (Years) 5 PER: total number of payments Quarterly Payment PMT quarterly payment student Grade INSTRUCTIONS 1 1. Enter your Student Number in cell 1 12. In cell FS (MFG Rebate) enter the last 4 digits of your student number as the amount Example: for student number 0123456, enter 3456 4. In cell F7 create a formula to calculate the amount of your Loan 4. In cell F3. Calculate the Rate per quarter 5. In cell 9. Calculate the Number of payments over the Term of the Loan 8 In cell F10 using the PMT Function Calculate your Quarterly Payment, using the information above in the 6. shaded cells. 2 17. Display the payment as a negative number Save the workbook as First Initial Last Name Student Number GPA, and submit in the Assignment Area by selecting Browse Computer and Attaching your Excel file. Then Save and submit. Example: KDi Paolo0123456GPA 23 TOTAL 4 4 3 17 4 1 1 20 8 2 20 23 22 23 Budget GP Buying a Car Aceste Ready 13 MB fa c 0 E F 0 H N 0 Points B Student Grade 1 1 42 42 Final Assignment GPA Calculations, PMT - Mortgage and Car Payment 1 Save the workbook as First Initial Last Name Student Number GPA Example KiPa 0123456GPA 2 In the documentation worksheet enter your name in cell student number in 15 and the date in cell. Co to the budget Worksheet and follow the instructions found there 4 Go to the GPA Worksheet and follow the instructions found there 5 Go to buying a Car Worksheet and follow the instructions found there Save the workbooks in initial state Student Number GPA, and submit your excellen the Assignment by selecting Browse Computer and Attaching your Excel file. Then Save and Submit Example: Kolo0123450GPA TOTAL = 8: 81 10 11 12 13 14 2) 23 150 150 15 16 12 18 19 20 21 Instructions Documentation Budget GPA Buying a Car Abwe Ry AL 1X Final Assignment A C D Final Assignment 2 GPA Calculations, PMT - Mortgage and Car Payment Student Points Grade 3 4 Author 5 Student Number 6 Date Purpose 1 1 1 To complete the final assignment for BUS207 3 14 Instructions Documentation Budget GPA Buying a Car 100 GON 3 E2 X lo student number 0123456 the down payment is 100 X 456 = $45.800. Use this information to complete the information in cells B3 to 110 and following the instructions D G Carlato Family Budget Student Number Cristofer and Mis Carlate of Windsor, Ontario are using Excel to track their family budget to determine whether they Points Student can afford the monthly loan payments that would come with the purchase of a new vacation home in Italy. The couple Grade is cordering a $420,000 home at a 2.95annual interest rate to be paid back over 30 years. They want to know the Mortgage 5 5 Impact that this mortgage will have on their budget. Their down payment is 100 times the last 3 digits of YOUR student Annual Interest Rate 2 2 number. For example, foe student number 0123456 the down payment is 100 X 456 $45,600. Use this information Interest Rate per Month to complete the information in cells 83 to 110 and following the instructions below 3 in Colt B2 type in your student number Years 2 2 In Cell By use a formula to calculate the amount the couple will borrow from the bank to obtain a mortgage Total Payments 4 In Cell 84 place the annual interest rate. In Cell use a formula to determine the monthly interest rate 10 Monthly Payment In Cell B7 place the number of years that the couple will have to pay for the mortope. in Cell B use a formula to determine the number of payments the couple will make over the wife of the mortgage 11 7 7 in Cell 10 use the PMT function to calculate the monthly mortgage payment. 12 2 2 Copy the formula from Cell C20 to the range 020-N20. 13 3 3 in the range C27:27, use the value in cell B10 as a positive number the decimal places), anturing it is set to holute, for the monthly met payment 14 5 5 In range C29-N29, use a formula to calculate Cristofer and Miastotal monthly expenses 15 42 42 TOTAL 16 17 Income Expenses Item Apr May Aut Sep Oct Ney Documentation Budget GPA Buying a Car Ac 9 9 9 Feb Mar Jun Dec E2 VIX fx student number 0123456 the down payment is 100 X 456 = $45,600. Use this information to complete the information in cells 83 to 10 and following the instructions D F G o 3 3 in the range the value in cell 550 policie number the decimal places, suring it is set to absolute for the monthly more payment 5 5 in range C29.29 use a formula to calculate Cristofer and total monthly expenses. 42 42 TOTAL 17 Income Expenses Income PSHE B Item Cristofer Mia Total Income Food Utilities Phone Insurance Car Travel Mortace Misc Total Expenses Net Income Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec 54,200 $ 4.2005 4,200 $ 4.2005 4,200 54,200 $4,200 5 4,200 $ 4.200 $ 4.2005 4,200 $ 3.500 $ 1,500 2.0005 2.500 1.500 2.000 2.500S 1.500 2.000 2.500 1,500 52.000 2.500 5 5205 250S 4755 4755 4755 4755 3005 1005 500 5 550 S 250S 450 s 165 $ 1655 1655 1505 150 S 150 S 150 1505 1355 135 S 170$ 170 $ 955 955 95 S 955 955 95 S 955 955 95$ 955 955 95 $ 365 3655 3655 3655 365 $ 3655 3655 3655 3655 365 S 365 365 5 5155 5155 515 S 5155 5155 5155 5155 5155 5155 5155 5155 515 5 $ 2.000 S $ - $ $ $ 8505 8505 $ S 3,200 Expenses 5 5505 5505 550 $ 9255 9255 925S 600$ 600$ 600 5 725 S 7255 725 NET 5 - 5 5 5 S 5 5 -- 15 5 5 5 - $ Budget GPA Buying a Car Documentation Aco AI Credo Crew G Tot PA La Con Next . 1 1 AAL 1. semester MOGLO ALEGRE SACHS EOMMODO 7 MES PRIE MATER 2.COM 10 D Student ID Teu Last Name Marin Test 2 Midterm Final Exam Final Average 12 First Name Homework 4 91 Category We EXCO To 16.10 THEO | L Tulcea Total 15 16 17 10240 95 100 77 92 3 95 14 14 21 30 N 2011 570011 22.116.6.23 2330100 34 35 5846-73 Teine N Rai Dale une D A Luk Part super Care Fernandes Anarpreet Budget GPA Buying a Car 75 4 83 61 80 100 34 100 100 B2 1 Documentation Rady BA A 10 12 11 1 1 15 c 0 Interest Rate (per Year) 4,16% RATE per quarter Term (Years) 5 PER: total number of payments Quarterly Payment PMT quarterly payment student Grade INSTRUCTIONS 1 1. Enter your Student Number in cell 1 12. In cell FS (MFG Rebate) enter the last 4 digits of your student number as the amount Example: for student number 0123456, enter 3456 4. In cell F7 create a formula to calculate the amount of your Loan 4. In cell F3. Calculate the Rate per quarter 5. In cell 9. Calculate the Number of payments over the Term of the Loan 8 In cell F10 using the PMT Function Calculate your Quarterly Payment, using the information above in the 6. shaded cells. 2 17. Display the payment as a negative number Save the workbook as First Initial Last Name Student Number GPA, and submit in the Assignment Area by selecting Browse Computer and Attaching your Excel file. Then Save and submit. Example: KDi Paolo0123456GPA 23 TOTAL 4 4 3 17 4 1 1 20 8 2 20 23 22 23 Budget GP Buying a Car Aceste Ready 13