can you please help by finding the answers, showing every steps and formulas used tu find those answers in Excel!!
Gabrielle and Dwyane have hired you to deliver some financial advice. They are 25 years old and have two children, ages 2 and 3, and live in Denver, Colorado. They work as engineers at a transportation company and currently earn $75,000 each (after-tax). They have stated that their financial goals are to: 1 Establish an adequate emergency fund 2 Pay off current debts 3 Purchase a 3 bedroom, 2 bathroom home in the Highlands Ranch area, where this type of home averages about $300,000 (they want to put down 20% as a down payment and finance the rest using a 6%, 30-year mortgage) 4 Create a college fund for their children (they plan for each child to enroll at the University of Colorado when they turn 18 and have estimated this will cost $50,000 for each child) 5 Establish an investment plan that will grow to $2,500,000 when they retire at age 65. 8,000 75,000 30,000 40,000 15,000 2,000 Family Financial Information Assets Checking Savings Cars Liabilities Student Loans Car Loans Credit Cards Monthly Outflow: Rent Insurance Utilities Food Daycare Kid Essentials Gas/Maintenance Credit Card Payments Student Loan Payments Car Payments Entertainment 1,200 100 250 500 400 100 250 200 250 500 150 7 Given that this family will likely need to invest in stocks to meet their long-term financial goals, explain the long-term and short-term stock investment strategies that are available to them. Be sure to include the benefits and risks of these strategies. 8 Calculate the monthly payment this family would need to make on their mortgage (show your TVM calculations). Explain how much interest will be paid over the life of this loan. Additionally, explain what would change if the family were to add $500 to this payment each month. 9 Recalculate this family's monthly outflow assuming your recommendations are implemented. Be sure to present this new "budget" line-by-line, in the same format presented above. (Note: if your new monthly outflow is greater than your monthly inflow from their incomes, please adjust your recommendations as they do not have any interest in changing employment or taking on additional jobs.) 7 Given that this family will likely need to invest in stocks to meet their long-term financial goals, explain the long-term and short-term stock investment strategies that are available to them. Be sure to include the benefits and risks of these strategies. 8 Calculate the monthly payment this family would need to make on their mortgage (show your TVM calculations). Explain how much interest will be paid over the life of this town. Additionally, explain what would change if the family were to add $500 to this payment cach month. 9 Recalculate this family's monthly outflow assuming your recommendations are implemented. Be sure to present this new "budget line-by-line, in the same format presented above. (Note: if your new monthly outflow is greater than your monthly inflow from their incomes, please adjust your recommendations as they do not have any interest in changing employment or taking on additional jobs.) Gabrielle and Dwyane have hired you to deliver some financial advice. They are 25 years old and have two children, ages 2 and 3, and live in Denver, Colorado. They work as engineers at a transportation company and currently earn $75,000 each (after-tax). They have stated that their financial goals are to: 1 Establish an adequate emergency fund 2 Pay off current debts 3 Purchase a 3 bedroom, 2 bathroom home in the Highlands Ranch area, where this type of home averages about $300,000 (they want to put down 20% as a down payment and finance the rest using a 6%, 30-year mortgage) 4 Create a college fund for their children (they plan for each child to enroll at the University of Colorado when they turn 18 and have estimated this will cost $50,000 for each child) 5 Establish an investment plan that will grow to $2,500,000 when they retire at age 65. 8,000 75,000 30,000 40,000 15,000 2,000 Family Financial Information Assets Checking Savings Cars Liabilities Student Loans Car Loans Credit Cards Monthly Outflow: Rent Insurance Utilities Food Daycare Kid Essentials Gas/Maintenance Credit Card Payments Student Loan Payments Car Payments Entertainment 1,200 100 250 500 400 100 250 200 250 500 150 7 Given that this family will likely need to invest in stocks to meet their long-term financial goals, explain the long-term and short-term stock investment strategies that are available to them. Be sure to include the benefits and risks of these strategies. 8 Calculate the monthly payment this family would need to make on their mortgage (show your TVM calculations). Explain how much interest will be paid over the life of this loan. Additionally, explain what would change if the family were to add $500 to this payment each month. 9 Recalculate this family's monthly outflow assuming your recommendations are implemented. Be sure to present this new "budget" line-by-line, in the same format presented above. (Note: if your new monthly outflow is greater than your monthly inflow from their incomes, please adjust your recommendations as they do not have any interest in changing employment or taking on additional jobs.) 7 Given that this family will likely need to invest in stocks to meet their long-term financial goals, explain the long-term and short-term stock investment strategies that are available to them. Be sure to include the benefits and risks of these strategies. 8 Calculate the monthly payment this family would need to make on their mortgage (show your TVM calculations). Explain how much interest will be paid over the life of this town. Additionally, explain what would change if the family were to add $500 to this payment cach month. 9 Recalculate this family's monthly outflow assuming your recommendations are implemented. Be sure to present this new "budget line-by-line, in the same format presented above. (Note: if your new monthly outflow is greater than your monthly inflow from their incomes, please adjust your recommendations as they do not have any interest in changing employment or taking on additional jobs.)
