- This mini-case is available at 8:00 and is due on 11:59pm on Sep 28, - You are required to show your wo stions. Please submit two (2) documents this word document with all answers written nswer boxes (50% of the grade), and (2) an excel Snect that shows how you reached these answers (50% of the grade). - Please type (Do not hand write) both your workings and the final answers in the designated solution areas, - Please feel free to extend the size of the solution boxes provided as you feel the necessity to do so. - Once you are done, please save this document as a PDF and upload it back + excel sheet that shows the answer formulas to the same position on blackboard that you used to download the case in the first place. Time Value of Money Mini-Project Mr. Donald Heffeman, a 35 years old account manager At Wells Fargo has gross annual income after all deductibles of $85.000. Mrs. Hefferan quit her job at Walmart to take care of their twin kids, Luke and Christine. So Mr. Heffernan is the only income eamer at his household Mr. Heffernan is filing income using the following "Married filing jointly tax rate schedule. Taxable income nuolax rais SO 151.301 230,451 411.50 230.450 411.300 33 1- Mr. Heffernan's net annual income is: 2- Mr. Heffernan's net Month 3- Mrs. Heffernan just won the state sweepstake. She got two options to get her prize. (1) To receive $250,000 today. Orto receive a monthly payment of S2000 for 25 years period. If Mrs. Heffernan appropriate discount rate is 6%. Which option should Mrs. Heffernan go with? Note: if Mrs. Heffernan choose to go with option 1, she will invest the $250,000 at 6% to generate monthly income for the 25 years period 4- The Heffernan's total monthy come Once Mr. Heffernan calculates his net monthly income from all sources, he decided to make a personal financial plan. Mr. Heffernan's financial targets include paying his student loan, paying the balance of credit cards, saving for retirement, and saving for his son's and daughter's college. 5- MR. Heffernan thinks it is finally time to start taking care of his student loan that has been outstanding for a while now. He has $120,000 outstanding balance. He monthly payments to pay If the interest - This mini-case is available at 8:00 and is due on 11:59pm on Sep 28, - You are required to show your wo stions. Please submit two (2) documents this word document with all answers written nswer boxes (50% of the grade), and (2) an excel Snect that shows how you reached these answers (50% of the grade). - Please type (Do not hand write) both your workings and the final answers in the designated solution areas, - Please feel free to extend the size of the solution boxes provided as you feel the necessity to do so. - Once you are done, please save this document as a PDF and upload it back + excel sheet that shows the answer formulas to the same position on blackboard that you used to download the case in the first place. Time Value of Money Mini-Project Mr. Donald Heffeman, a 35 years old account manager At Wells Fargo has gross annual income after all deductibles of $85.000. Mrs. Hefferan quit her job at Walmart to take care of their twin kids, Luke and Christine. So Mr. Heffernan is the only income eamer at his household Mr. Heffernan is filing income using the following "Married filing jointly tax rate schedule. Taxable income nuolax rais SO 151.301 230,451 411.50 230.450 411.300 33 1- Mr. Heffernan's net annual income is: 2- Mr. Heffernan's net Month 3- Mrs. Heffernan just won the state sweepstake. She got two options to get her prize. (1) To receive $250,000 today. Orto receive a monthly payment of S2000 for 25 years period. If Mrs. Heffernan appropriate discount rate is 6%. Which option should Mrs. Heffernan go with? Note: if Mrs. Heffernan choose to go with option 1, she will invest the $250,000 at 6% to generate monthly income for the 25 years period 4- The Heffernan's total monthy come Once Mr. Heffernan calculates his net monthly income from all sources, he decided to make a personal financial plan. Mr. Heffernan's financial targets include paying his student loan, paying the balance of credit cards, saving for retirement, and saving for his son's and daughter's college. 5- MR. Heffernan thinks it is finally time to start taking care of his student loan that has been outstanding for a while now. He has $120,000 outstanding balance. He monthly payments to pay If the interest