Application Time! Jessica is thinking about going back to...

Application Time! Jessica is thinking about going back to school full time and receive a Master's in Accounting. Part of her decision will be based on the return on investment of Graduate School Help Jessica find the ROI of going back to school. (1) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information. Q8 How much is going back to school going to cost? Reminder: Show the TVM inputs and calculate in Excel Q9 How much money will be forgone will attending school? Reminder: Show the TVM inputs and calculate in Excel. Q10 What is the total cost? (cost of college + forgone salary) Q11 What is the 15 yr. ROI of attending graduate school? Reminder: Show the TVM inputs and calculate in Excel. Q12 Is this is a good ROI or not? NPER RATE PV PMT FV 3 3.00% 0 $31,000 #N/A NPER RATE PV PMT FV 3 4.00% 0 $58,500 #N/A NPER RATE PV PMT FV 3 1% 278,431.50 ($94,672.87) $322,500.00 Hint: The total cost Hint: With - Without Masters Degree

Transcript

00:01 Hello students, to solve the questions using the microsoft excel, so for the 10th question, as to compute the monthly cost of the gas, so in cell c21, in terms of formula, the number of the miles you accept to drive each month, divide the value of the number of the miles by the average mpg for the vehicle multiplied by the price of the gallons of the gas, so that will be as c21 is equal to as the data of node a5 by the data of node of a6 into b21 into b21, so as the second, this is of a part and the second is b is to copy the cell, copy the formula from cell c2 to add a proper cell for the other cells, copy the formula, copy the formula from cell c21 and paste to other and paste to other to other as c22, c23, c24 respectively, now as the if the cell d21 is to d24, d24 display an error or the value of 0, if it display the value of 0, the formula checks for an error, so d if still can't find the error, try displaying the prediction error, then as for the next, for the 11th one, to compute the monthly cost of the maintenance in cell c22, enter the formula as c22 is as c12 by 12, c12 by 12, where the formula copy from c12 to copy the formula from c22 and paste into the c23 as well as 24, so the next, the 12th is to compute the cost of the insurance, as to compute the monthly cost of insurance in cell c23, enter the formula to calculate the monthly cost of an insurance as c23 is equal to c14 by 12, so then copy and paste formula c23 into the other vehicles that is the c24, c24, now the next is as in cell c24 is to f24, compute the monthly cost for each of the vehicle, compute the monthly cost for each of the vehicle, so for that you will be writing the formula for d24 as the c21 plus c22 plus c23 and for this is and for the formula for the e24, you will be writing as d21 plus that is the total cost for the vehicles to that is for vehicle to d21, d22 plus d23 and the formula for f24, it will be written as the e21 plus e22 plus e23, so the next is to determine which vehicles are affordable, so to determine which vehicles are affordable in column c, in the column c as enter the formula using the if function to display the yes, if the total monthly cost is less than or equal to the total monthly cost amount available in cell b12, so for that enter the formula as cell 21 into the cell 21, if f21 is less than or equal to to the dollar of in the b7 column as else print as no, then copy this formula from c21 and appropriate to other c22, c23, c24 respectively, displace the formula and use an error checking skill learned in this lesson to trick around and fix any of the errors...

Question

Please give Ace some feedback