80.2K

Verified Solution

Link Copied!

Century Gothic 10 ' === 29 Wrap Paste BIU A De $ % 88 Conditional Formuta Cell Formatting Table See Number Derfor Opboard Jon Higment cets E2 1 X fr In Cell B4 place the annual interest rate. A 8 D E F G M 764581 Points 2.95% 2.95% 5 2 3 Student Number 2 3 Morigogo 4 Annual Interest Rate S Interest Rate per Month 8 Years Totol Payments 19 10 Monthly Payment 11 12 2 4 Student Grade Cristofer and Mio Corfoto of Windsor, Ontario are using Excel to track their family budgetto delermine whether they can afford the monthly loon payments that would come with the purchase of a new vacation home in toly The couple is considering a $420.000 home at a 2.95% annual interest rate to be paid back over year. They want to know the impact that this mortgage will have on their budget. Their down payment is 100 limes the last 2 digits of YOUR student number. For example for student number 0123456 the down payment is 100 X 456 - $45.400 Use this information to complete the information in cells 83 to B10 and following the instructions below in Cell B2 type in your student number in Cell B3 vie a formula to calculate the amount the couple will borrow from the bank to obtain a mortgage In Cel 84 place the annual interest rate in Cell B5 use a formula to determine the monthly interest rate in Cell B7 place the number of years that the couple will have to pay for the mortgage in Cell Ba use a formula to determine the number of payments the couple will make over the life of the mortgage In Cell B10 use the PMT function to calculate the monthly mortgage payment Copy the formula from Cell C20 to the range 020 N20 in the range C27.N27 vse the value in coll 10 a positive number (no decimal places) on the monthly mortgage payment In range C29 N2 use a formula o calculate Cristaler and Mia's total monthly expenses 0 TOTAL 9 2 2 3 5 42 13 14 15 16 17 Income & Expenses 16 19 Income 20 Jun Horn Cristofer Mo Total income Food Ulities Phone Insurance Car Travel Mortgage Misc Total Expenses Matiname Documentation Jan Feb Mor Apr May Jul Aug Sep Oct Nov Dec $ 4200 4200 4,2005,200 $4,200 4.200114200 $4,200 $ 4200 $ 4.2004 2005 3.500 $ 1500 2000 2.500 51 500 2.000 25001 500 $2,000 $ 2.500 1500 $ 2.000 2.500 $ 52015 250S 4255 4755 4755 4755 300 $ 300S 500 $ 5505 2015 450 $ 165 $ 165$ 165 150 150 $ 150$ 150 $ 150 $ 135 5 135$ 1705 170 95$ 955 95$ 95 $ 955 95$ 95$ 95 $ 955 955 955 95 $ 3653 345$ 3653 365$ 365 365$ 385$ 365 $ 3653 3655 365 $ 365 $ 515$ 515$ 5155 515$ 5153 515 515$ SISTES 5155 5155 5155 $15 3 $ 2.000 $ $ $ BSOS 850 $ $ $ 3.2005 $ 550 $ 550S 5505 9255 925 925$ 8005 6003 7253 7255 725 24 25 Expenses N 29 NET Instructions Budget GPA Buying a Car Type here to search O File Final Anagnment GPA PMI Car Mar 300 Last Modified Home Page Layout Formulas Data Review View Help X Century Gothic 11 - A A ab Wiap ih Merge Center - 5 - % 9 Conditionale Fog- obeles - Ciboard FO Alignment 013 100 2 OSS Creus La Grade Corresponding Number Orade 4 3 3 3 4 ca Correlator Weged Semester Number Grace Code Total GPA A 12 A 4 12 4 16 1 12 2 70 B3210 4 3 3 2 1 E 3 F Homework 100 Test 2 94 Category Homewo 3 MALO Semester + ACC Acting Concept 5 ORE ECN110 Marcos MH 146 Maths Personale ROUTE COM 103 DUI Communication 10 11 12 Shudent ID 13 478 14024491 151965193 16518-8-15 17 290.9456 18 521 4.87 19969.6.95 20 218-7.9 21. 576.8.31 22. 166-6-22 25 389-0-90 249594.44 25 504 6.73 26 230-8-98 Tea 1 93 22 85 78 pa 88 35 Tout 2 Weigh 0.40 0.10 0.10 0.15 0.25 10 Final Exam Total Los Name First Name Aron Kenneth Manson ummah Blankenship Com Brenner Patrice Camacho Mesa Chavet Paine Chu Kasin bale Lund Dougherty Amy Eubanks Pearl Eugene Coro Femander Miguel KOU Amanpree! Singh Lagdeep 90 98 89 100 77 81 90 82 61 36 100 1222 90 80 89 71 81 Mid Final Final Average 9 93 1 94 59 142 85 75 123 95 25 116 87 22 120 195 95 100 1.4 36 94 69 O 83 B3 0 80 86 75 67 O 84 82 0 100 911 0 36 89 0 78 80 29 75 81 100 94 64 90 100 87 28 Points 12 29 10 31 22 33 3 6 6 2 3 B Student Follow the instructions below: Grade octuoludes Look them up in your heve scent and you CANNOT make these up. They MUST be your actuals or you will receive o ZERO grade on the GPA portion of your conset in the range DHD place the correspondro Number of that represent Relatet grade in the count in Califoglule the wind Fotal for AOCH10 Cooy the formula from Call to the ESE CATEO them function to the range In a formulato colocate you cometer GPA My Budget GPA Buying a Car + Instructions Documentation Century Gothic 11 A A Wrap Text Past ru - A Merge Center General $% Conditional Format we can Formatting Opbed Fort Agnment 13 100 5 COM 10 ens Communication 1 12 & 7015760427050 10 Category Homowa To] Tos Midlom Final Exam Total 0.40 0.10 010 O. 1.00 12 Student ID 51570378 14 07645 TS 1945.98 18 518-6-18 17290 9.56 18 521-487 10.909.6.95 20 218-7-91 21 6768 31 12165-6-22 39.90 24.959-444 25 5044-6-73 261736.90 27 28 Last Name First Name Homework Teal 1 Test 2 Aaron Midterm Final Exam Final Average Kenneth 100 93 96 92 Hansen Gummah 91 87 194 89 142 Blankenshin Come 90 88 BS 85 75 128 Banner Patrick 98 78 82 95 75 Camacho Melissa 29 98 90 87 92 120 Chaves Elaine 100 88 20 05 95 100 Chu Kexin 77 92 83 84 86 Dole Juno 81 78 20 24 9 Dougherty Amy 90 BO 31 8 B3 0 Eubanks Pearl 82 79 79 20 88 0 Eugene Ciora 61 75 64 75 67 O Femandez Miguel 86 81 90 84 82 Kaur Amanpreet 100 100 100 100 21 Singh Jagdeep 92 04 87 86 80 0 Points Student Grade Follow the instructions below: actual grades Look Them up in your sis. I have ces ond you CANNOT moke 12 these vo They MUST bevor ofval grades or you will receive a ZERO grade on the GPA portion of your owignment in the range of behending Numberg GFA tal represent 6 your lofter grade in the course 6 in Cel 4 use a fomula to calculate the weighted total for ACOITO 2 Copy the formula from Call E4 to the Forge 3 In Cell Elemunction to total therangela 8 in Cell Flow a formula to calculate your bemester GPA in Cell 113 ve o formula to colculate the WEC Final Average for the student 20 by using the groom in the range DISHI3 and the weights in the range L13L17 in Call 13 mokeve that belis 3L17 used in the calculation are all 5 absoluto references 3 Copy the fomula in Cell 13 to the range 1149126 16 Use Goal Seekroonimine the Exam Crado Dale would need in order to have ang Average of B0 81 0 TOTAL Instructions Documentation Budget GPA Buying a car Century Gothic 10 ' === 29 Wrap Paste BIU A De $ % 88 Conditional Formuta Cell Formatting Table See Number Derfor Opboard Jon Higment cets E2 1 X fr In Cell B4 place the annual interest rate. A 8 D E F G M 764581 Points 2.95% 2.95% 5 2 3 Student Number 2 3 Morigogo 4 Annual Interest Rate S Interest Rate per Month 8 Years Totol Payments 19 10 Monthly Payment 11 12 2 4 Student Grade Cristofer and Mio Corfoto of Windsor, Ontario are using Excel to track their family budgetto delermine whether they can afford the monthly loon payments that would come with the purchase of a new vacation home in toly The couple is considering a $420.000 home at a 2.95% annual interest rate to be paid back over year. They want to know the impact that this mortgage will have on their budget. Their down payment is 100 limes the last 2 digits of YOUR student number. For example for student number 0123456 the down payment is 100 X 456 - $45.400 Use this information to complete the information in cells 83 to B10 and following the instructions below in Cell B2 type in your student number in Cell B3 vie a formula to calculate the amount the couple will borrow from the bank to obtain a mortgage In Cel 84 place the annual interest rate in Cell B5 use a formula to determine the monthly interest rate in Cell B7 place the number of years that the couple will have to pay for the mortgage in Cell Ba use a formula to determine the number of payments the couple will make over the life of the mortgage In Cell B10 use the PMT function to calculate the monthly mortgage payment Copy the formula from Cell C20 to the range 020 N20 in the range C27.N27 vse the value in coll 10 a positive number (no decimal places) on the monthly mortgage payment In range C29 N2 use a formula o calculate Cristaler and Mia's total monthly expenses 0 TOTAL 9 2 2 3 5 42 13 14 15 16 17 Income & Expenses 16 19 Income 20 Jun Horn Cristofer Mo Total income Food Ulities Phone Insurance Car Travel Mortgage Misc Total Expenses Matiname Documentation Jan Feb Mor Apr May Jul Aug Sep Oct Nov Dec $ 4200 4200 4,2005,200 $4,200 4.200114200 $4,200 $ 4200 $ 4.2004 2005 3.500 $ 1500 2000 2.500 51 500 2.000 25001 500 $2,000 $ 2.500 1500 $ 2.000 2.500 $ 52015 250S 4255 4755 4755 4755 300 $ 300S 500 $ 5505 2015 450 $ 165 $ 165$ 165 150 150 $ 150$ 150 $ 150 $ 135 5 135$ 1705 170 95$ 955 95$ 95 $ 955 95$ 95$ 95 $ 955 955 955 95 $ 3653 345$ 3653 365$ 365 365$ 385$ 365 $ 3653 3655 365 $ 365 $ 515$ 515$ 5155 515$ 5153 515 515$ SISTES 5155 5155 5155 $15 3 $ 2.000 $ $ $ BSOS 850 $ $ $ 3.2005 $ 550 $ 550S 5505 9255 925 925$ 8005 6003 7253 7255 725 24 25 Expenses N 29 NET Instructions Budget GPA Buying a Car Type here to search O File Final Anagnment GPA PMI Car Mar 300 Last Modified Home Page Layout Formulas Data Review View Help X Century Gothic 11 - A A ab Wiap ih Merge Center - 5 - % 9 Conditionale Fog- obeles - Ciboard FO Alignment 013 100 2 OSS Creus La Grade Corresponding Number Orade 4 3 3 3 4 ca Correlator Weged Semester Number Grace Code Total GPA A 12 A 4 12 4 16 1 12 2 70 B3210 4 3 3 2 1 E 3 F Homework 100 Test 2 94 Category Homewo 3 MALO Semester + ACC Acting Concept 5 ORE ECN110 Marcos MH 146 Maths Personale ROUTE COM 103 DUI Communication 10 11 12 Shudent ID 13 478 14024491 151965193 16518-8-15 17 290.9456 18 521 4.87 19969.6.95 20 218-7.9 21. 576.8.31 22. 166-6-22 25 389-0-90 249594.44 25 504 6.73 26 230-8-98 Tea 1 93 22 85 78 pa 88 35 Tout 2 Weigh 0.40 0.10 0.10 0.15 0.25 10 Final Exam Total Los Name First Name Aron Kenneth Manson ummah Blankenship Com Brenner Patrice Camacho Mesa Chavet Paine Chu Kasin bale Lund Dougherty Amy Eubanks Pearl Eugene Coro Femander Miguel KOU Amanpree! Singh Lagdeep 90 98 89 100 77 81 90 82 61 36 100 1222 90 80 89 71 81 Mid Final Final Average 9 93 1 94 59 142 85 75 123 95 25 116 87 22 120 195 95 100 1.4 36 94 69 O 83 B3 0 80 86 75 67 O 84 82 0 100 911 0 36 89 0 78 80 29 75 81 100 94 64 90 100 87 28 Points 12 29 10 31 22 33 3 6 6 2 3 B Student Follow the instructions below: Grade octuoludes Look them up in your heve scent and you CANNOT make these up. They MUST be your actuals or you will receive o ZERO grade on the GPA portion of your conset in the range DHD place the correspondro Number of that represent Relatet grade in the count in Califoglule the wind Fotal for AOCH10 Cooy the formula from Call to the ESE CATEO them function to the range In a formulato colocate you cometer GPA My Budget GPA Buying a Car + Instructions Documentation Century Gothic 11 A A Wrap Text Past ru - A Merge Center General $% Conditional Format we can Formatting Opbed Fort Agnment 13 100 5 COM 10 ens Communication 1 12 & 7015760427050 10 Category Homowa To] Tos Midlom Final Exam Total 0.40 0.10 010 O. 1.00 12 Student ID 51570378 14 07645 TS 1945.98 18 518-6-18 17290 9.56 18 521-487 10.909.6.95 20 218-7-91 21 6768 31 12165-6-22 39.90 24.959-444 25 5044-6-73 261736.90 27 28 Last Name First Name Homework Teal 1 Test 2 Aaron Midterm Final Exam Final Average Kenneth 100 93 96 92 Hansen Gummah 91 87 194 89 142 Blankenshin Come 90 88 BS 85 75 128 Banner Patrick 98 78 82 95 75 Camacho Melissa 29 98 90 87 92 120 Chaves Elaine 100 88 20 05 95 100 Chu Kexin 77 92 83 84 86 Dole Juno 81 78 20 24 9 Dougherty Amy 90 BO 31 8 B3 0 Eubanks Pearl 82 79 79 20 88 0 Eugene Ciora 61 75 64 75 67 O Femandez Miguel 86 81 90 84 82 Kaur Amanpreet 100 100 100 100 21 Singh Jagdeep 92 04 87 86 80 0 Points Student Grade Follow the instructions below: actual grades Look Them up in your sis. I have ces ond you CANNOT moke 12 these vo They MUST bevor ofval grades or you will receive a ZERO grade on the GPA portion of your owignment in the range of behending Numberg GFA tal represent 6 your lofter grade in the course 6 in Cel 4 use a fomula to calculate the weighted total for ACOITO 2 Copy the formula from Call E4 to the Forge 3 In Cell Elemunction to total therangela 8 in Cell Flow a formula to calculate your bemester GPA in Cell 113 ve o formula to colculate the WEC Final Average for the student 20 by using the groom in the range DISHI3 and the weights in the range L13L17 in Call 13 mokeve that belis 3L17 used in the calculation are all 5 absoluto references 3 Copy the fomula in Cell 13 to the range 1149126 16 Use Goal Seekroonimine the Exam Crado Dale would need in order to have ang Average of B0 81 0 TOTAL Instructions Documentation Budget GPA Buying a car

Answer & Explanation Solved by verified expert

See Answer