could you please help find answers by showing every steps and each formula 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 4 Recommend some steps this family could take to start chipping away at their current debt balances. 5 Assuming a 7% return on investments, show this family how much they should be investing each month to fund their education and retirement goals (show your TVM calculations), Be sure to explain to them how various economic conditions could derail these goals, using the current economic climate as an example. 6 When talking with Dawayne, you have found his risk tolerance to be a bit on the aggressive side. Compare the advantages and disadvantages of investments that carry less risk (like bonds) to those that carry more risk (like stocks and real estate). Be sure to mention the relationship between bond prices and interest rates given the unusual current economic climate. Further, be sure that Dawayne understands how to compare the returns of municipal bonds to the returns of other investment products. 4 Recommend some steps this family could take to start chipping away at their current debt balances. 5 Assuming a 7% return on investments, show this family how much they should be investing cach month to fund their education and retirement goals (show your TVM calculations). Be sure to explain to them how various economic conditions could derail these goals, using the current economic climate as an example. 6 When talking with Dawayne, you have found his risk tolerance to be a bit on the aggressive side Compare the advantages and disadvantages of investments that carry less risk (like bonds) to those that carry more risk (like stocks and real estate). Be sure to mention the relationship between bond prices and interest rates given the unusual current economic climate. Further, be sure that Dawayne understand how to compare the returns of municipal bonds to the retums of other investment products, 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 4 Recommend some steps this family could take to start chipping away at their current debt balances. 5 Assuming a 7% return on investments, show this family how much they should be investing each month to fund their education and retirement goals (show your TVM calculations), Be sure to explain to them how various economic conditions could derail these goals, using the current economic climate as an example. 6 When talking with Dawayne, you have found his risk tolerance to be a bit on the aggressive side. Compare the advantages and disadvantages of investments that carry less risk (like bonds) to those that carry more risk (like stocks and real estate). Be sure to mention the relationship between bond prices and interest rates given the unusual current economic climate. Further, be sure that Dawayne understands how to compare the returns of municipal bonds to the returns of other investment products. 4 Recommend some steps this family could take to start chipping away at their current debt balances. 5 Assuming a 7% return on investments, show this family how much they should be investing cach month to fund their education and retirement goals (show your TVM calculations). Be sure to explain to them how various economic conditions could derail these goals, using the current economic climate as an example. 6 When talking with Dawayne, you have found his risk tolerance to be a bit on the aggressive side Compare the advantages and disadvantages of investments that carry less risk (like bonds) to those that carry more risk (like stocks and real estate). Be sure to mention the relationship between bond prices and interest rates given the unusual current economic climate. Further, be sure that Dawayne understand how to compare the returns of municipal bonds to the retums of other investment products
