please I need help with this questions
pleqse can you use Excel and also show each excel formula and steps used in excel to show the answer. you can zoom to see the question
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 Deliverables: I Given the age, marital status, household makeup, and employment situation of this family, list the specific short-leum and long-term financial goals and activities this family should be focused on Be specific (For example, what dollar amount should they have in their emergency fund? Why that amount? Etc.) 2 Explain to this family how safety, risk, income, growth, and liquidity affect an investment program, Be sure to mention the specific types of risk that are inherent to investments, 3 Recommend the percentage of growth assets that this family should be invested in given their investment horizon. Explain how you came up with this number and what types of growth assets are available to them. 1 Given the age, marital status, household makeup, and employment situation of this family, list the specific short-term and long-term financial goals and activities this family should be focused on Be specific (For example, what dollar amount should they have in their emergency fund? Why that amount? Etc.) 2 Explain to this family how safety, risk, income, growth, and liquidity affect an investment program. Be sure to mention the specific types of risk that are inherent to investments. 3 Recommend the percentage of growth assets that this family should be invested in given their investment horizon. Explain how you came up with this number and what types of growth assets are available to them. 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 Deliverables: I Given the age, marital status, household makeup, and employment situation of this family, list the specific short-leum and long-term financial goals and activities this family should be focused on Be specific (For example, what dollar amount should they have in their emergency fund? Why that amount? Etc.) 2 Explain to this family how safety, risk, income, growth, and liquidity affect an investment program, Be sure to mention the specific types of risk that are inherent to investments, 3 Recommend the percentage of growth assets that this family should be invested in given their investment horizon. Explain how you came up with this number and what types of growth assets are available to them. 1 Given the age, marital status, household makeup, and employment situation of this family, list the specific short-term and long-term financial goals and activities this family should be focused on Be specific (For example, what dollar amount should they have in their emergency fund? Why that amount? Etc.) 2 Explain to this family how safety, risk, income, growth, and liquidity affect an investment program. Be sure to mention the specific types of risk that are inherent to investments. 3 Recommend the percentage of growth assets that this family should be invested in given their investment horizon. Explain how you came up with this number and what types of growth assets are available to them
