Given the following information, develop a beginning-of-the-year statement of financial position. Beginning date End date Client...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the following information, develop a beginning-of-the-year statement of financial position. Beginning date End date Client name 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 (prindpal residence) Reinvestment in savings account/trust Salary-Frank Salary-Lois Savings Savings account/trust fund interest Trust fund Tuition and education expenses Utilities January 1, December 31, 2015 Frank and Lois Beginnin Balance $0 $0 $15,432 $20,000 $5,750 $10,000 $10,870 $36,000 $0 $6,000 $72,960 $85,000 $13,500 $100,00 Ending Income/Expenses Amount (Yearly) Balance $750 $990 $1,500 $990 $10,436 $18,000 $5,175 $15,570 $10,417 $34,000 $1,200 $6,100 $72,164 $89,250 $14,175 $105,000 $381 $4,996 $600 $2,124 $2,400 $3,600 $1,707 $453 $4,200 $11,449 $4,800 $534 $4,800 $5,808 $796 $850 $5,675 $25,000 $33,000 $5,675 $2,893 $2,100 Additional transactions: - Made a joint gift of bedroom furniture with a fair market value of $2,000 to Frank's little sister - Section 401(k) plan employer match = 3 % of income - Bought a go-cart for their son for $1,200 1. Create a personal statement of cash flows. 2. Create a statement of changes in net worth. 3. Create an end-of-the-year statement of financial position. 4. Use the results from the above problems to calculate the following ratios for year- end: a) b) Current ratio Emergency fund 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 1) Return on investments m) Investment assets to annual gross income Given the following information, develop a beginning-of-the-year statement of financial position. Beginning date End date Client name 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 (prindpal residence) Reinvestment in savings account/trust Salary-Frank Salary-Lois Savings Savings account/trust fund interest Trust fund Tuition and education expenses Utilities January 1, December 31, 2015 Frank and Lois Beginnin Balance $0 $0 $15,432 $20,000 $5,750 $10,000 $10,870 $36,000 $0 $6,000 $72,960 $85,000 $13,500 $100,00 Ending Income/Expenses Amount (Yearly) Balance $750 $990 $1,500 $990 $10,436 $18,000 $5,175 $15,570 $10,417 $34,000 $1,200 $6,100 $72,164 $89,250 $14,175 $105,000 $381 $4,996 $600 $2,124 $2,400 $3,600 $1,707 $453 $4,200 $11,449 $4,800 $534 $4,800 $5,808 $796 $850 $5,675 $25,000 $33,000 $5,675 $2,893 $2,100 Additional transactions: - Made a joint gift of bedroom furniture with a fair market value of $2,000 to Frank's little sister - Section 401(k) plan employer match = 3 % of income - Bought a go-cart for their son for $1,200 1. Create a personal statement of cash flows. 2. Create a statement of changes in net worth. 3. Create an end-of-the-year statement of financial position. 4. Use the results from the above problems to calculate the following ratios for year- end: a) b) Current ratio Emergency fund 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 1) Return on investments m) Investment assets to annual gross income
Expert Answer:
Answer rating: 100% (QA)
Personal Statement of Cash Flows Operating Activities SalaryFrank 85000 SalaryLois 72960 Child support 6000 Interest income 850 Auto loan interest 381 Mortgage payment interest 4200 FICA and federal i... View the full answer
Related Book For
Strategic Management A Competitive Advantage Approach Concepts
ISBN: 978-0133444797
15th edition
Authors: Fred R. David, Forest R. David
Posted Date:
Students also viewed these accounting questions
-
M Which of the following statements about the adversary system is true? Multiple Choice O The judge, in an adversary system, is actively involved in determining the facts of a case. The judges have a...
-
Given the following information and that contained in Problems 5 and 6, construct a forecast balance sheet as of June 30,20X2, for the Central City Department Store. (Assume that accounts payable...
-
Given the following information, construct an ANOVA table. Use Table 4. (Round intermediate values to 4 decimal places and your answers except "df" to 2 decimal places.) SST = 70.04; SSTR = 8.52; c =...
-
The engines of most rockets produce a constant thrust (forward force). However, when a rocket is fired, its acceleration increases with time as the engine continues to operate. Is this situation a...
-
Beam ABCD is simply supported at B and C and has overhangs at each end (see figure). The span length is L and each overhang has length L/3. A uniform load of intensity q acts along the entire length...
-
Refer to the Journal of Food Science (Feb. 2014) taste-testing study, Exercise 10.80 (p. 551). Recall that the researchers evaluated the general Labeled Magnitude Scale (gLMS), used to rate the...
-
A Sampling Distribution for Gender in the Rock and Roll Hall of Fame Exercise 3.37 tells us that 47 of the 303 inductees to the Rock and Roll Hall of Fame have been female or have included female...
-
Assessing a strategy to control quality cost Lucy Sawyer, who owns and operates Sawyer Toy Company, is a perfectionist. She believes literally in the zero-defects approach to quality control. Her...
-
Individual Key Learning Report Individual Key Learning Report A+ Individual Report on Key Learnings Students are required to prepare an individual report at the end of the semester to present the...
-
In a volumetric determination of an analyte A, the data obtained and their standard deviations are as follows: From the data, find the coefficient of variation of the final result for the % A that is...
-
A food worker has been sick with diarrhea for a few days, but she is starting to feel better. She hasn't had diarrhea in the last six hours, and she is scheduled to work in an hour. What should the...
-
According to this assignment, what is the amount of debits and credits to the cash account?
-
What prividleges do accountants have and how might that create blind spots?
-
Perform relevant analysis of the limiting factor (16,600 labour hours), determine how many units of each product to be produced and sold in order to maximise the total contribution margin?
-
HyperLens has the following budgeted cost information: Budgeted manufacturing overhead $1,928,500 Budgeted machine hours 8,000 Budgeted direct labor hours 4,200 Budgeted units 40,000 Cost Pool Total...
-
Brew Shack is a small brewery that is trying to better understand its costs. The company, which currently uses traditional job-order costing, allocates overhead costs using a single cost driver. The...
-
Background checks are an issue faced by many companies, as sensitive information is now more public than ever. OfficeAway is no exception, as the company scans paper into digital files, including...
-
To balance the chemical equation SiH3 + O2 SiO2 + HO, you could introduce coefficients a, b, c, d and write aSiH3 + bO2 cSiO + dHO then write linear equations for each element. The equation for Si...
-
Think of an organization you are very familiar with. List three resources of that entity that are empirical indicators.
-
Distinguish between market commonality and resource similarity. Apply these concepts to two rival firms that you are familiar with.
-
Why should division head persons have the title president rather than vice president?
-
A food processor claims that at most \(10 \%\) of her jars of instant coffee contain less coffee than claimed on the label. To test this claim, 16 jars of her instant coffee are randomly selected and...
-
Refer to Exercise 4.2. (a) Determine the cumulative probability distribution \(F(x)\). (b) Graph the probability distribution of \(f(x)\) as a bar chart and below it graph \(F(x)\). Data From...
-
Four emergency radios are available for rescue workers but one does not work properly. Two randomly selected radios are taken on a rescue mission. Let \(X\) be the number that work properly between...
Study smarter with the SolutionInn App