Question: can someone help with 9&10 using excel Time Value of Money Mini-Project Job GAS RITA Mr. Donald Heffernan, a 35 years old account manap At

Time Value of Money Mini-Project Job GAS RITA Mr. Donald Heffernan, a 35 years old account manap At Wells Fargo has gross annual income after all deductibles of $85,000. Mrs. Heffernan quit her job at Walmart to take care of their twin kids, Luke and Christine. So Mr. Heffernan is the only income earner at his house hold. PROPE Housa Mr. Heffernan is filing income using the following "Married filing jointly" tax rate schedule. Taxable income over Not over Tax rate $0 18,450 10% 18,451 74,900 15% 74,901 151,200 25% 151,201 230,450 28% 230,451 411,500 33% 411,501 464,850 35% 464,851 39.6% 1- Mr. Heffernan's net annual income is: 72,163 9- If Mr. Heffernan can actually stick to his financial plan, how long could his retirement savings afford for his living. Assuming that his estimated annual expenses after retirements is $48000, and that his retirement savings are going to be saved in a bank accounts that earns 2%. 10- What is the residual income that is available to Mr. Heffernan after satisfying the needs for his financial plan
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
