Please do these problems on excel and show me the screenshot of the code!

1. Given the following information, develop abeginning-of-the-year statement of financial position.

2, Use the data in Problem 1 to create a personal statement of cash flows.

3. Use the data in Problem 1 to create a statement of net worth.

4. Use the data in Problem 1 to create an end-of-the-year statement of financial position.

5. Use the results from the above problems to calculate the following ratios for yearend: a. Emergency fund b. Current ratio c. Total debt to net worth d. Long-term debt to net worth e. Total debt to total assets f. Long-term debt to total assets g. Monthly housing costs to monthly gross income h. Monthly housing costs and other debt repayments to monthly gross income i. Savings ratio j. Net cash flow plus savings to annual gross income k. Income on investments I. Return on investments m. Investment assets to annual gross income

6. Discuss the financial position of the Foxes as based on the ratios you calculated in the previous problem.

Beginning date End date Client name January 1, 2013 December 31, 2013 Frank and Lois Fox Ending Income/Expenses Beginning Balance Balance Amount (Yearly) 750 $990 Section 401 (k) plan deferrals Section 401(k) plan-Frank Section 403(b) plan deferrrals Section 403(b) plan-Lois Auto loan Auto loan interest Auto loan principal Auto maintenance Automobile-Frank Automobile-Lois Automobile insurance premiums Checking Child support Clothing Credit card Credit card payments interest Credit card payments principal Entertainment FICA and federal income tax (W/H) Food Furniture/household Go-cart Homeowners insurance premiums Jewelry Maid/child care Mortgage on residence Mortgage payment interest Mortgage payment principal Personal residence Property tax (principal residence) Reinvestment in savings account/trust Salary-Frank Salary-Lois Savings Savings account/trust fund interest Trust fund $0 $1,500 $0 $15,432 $990 $10,436 $381 $4,996 $600 $20,000 $5,750 $18,000 $5,175 $2,124 $10,000 $15,570 $2,400 $3,600 $10,870 $10,417 $1,707 $453 $4,200 $11,449 $4,800 $36,000 $34,000 $0 $6,000 $72,960 $1,200 $6,100 $72,164 $534 $4,800 $5,808 $796 $85,000 $89,250 $850 $5,675 $25,000 $33,000 $13,500 $14,175 $5,675 $100,000 $105,000 Beginning date End date Client name January 1, 2013 December 31, 2013 Frank and Lois Fox Ending Income/Expenses Beginning Balance Balance Amount (Yearly) 750 $990 Section 401 (k) plan deferrals Section 401(k) plan-Frank Section 403(b) plan deferrrals Section 403(b) plan-Lois Auto loan Auto loan interest Auto loan principal Auto maintenance Automobile-Frank Automobile-Lois Automobile insurance premiums Checking Child support Clothing Credit card Credit card payments interest Credit card payments principal Entertainment FICA and federal income tax (W/H) Food Furniture/household Go-cart Homeowners insurance premiums Jewelry Maid/child care Mortgage on residence Mortgage payment interest Mortgage payment principal Personal residence Property tax (principal residence) Reinvestment in savings account/trust Salary-Frank Salary-Lois Savings Savings account/trust fund interest Trust fund $0 $1,500 $0 $15,432 $990 $10,436 $381 $4,996 $600 $20,000 $5,750 $18,000 $5,175 $2,124 $10,000 $15,570 $2,400 $3,600 $10,870 $10,417 $1,707 $453 $4,200 $11,449 $4,800 $36,000 $34,000 $0 $6,000 $72,960 $1,200 $6,100 $72,164 $534 $4,800 $5,808 $796 $85,000 $89,250 $850 $5,675 $25,000 $33,000 $13,500 $14,175 $5,675 $100,000 $105,000