Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. . . Create a balance sheet as of December 31st, 2014 and a cash flow statement for the three months ending 12/31/14 using the

image text in transcribedimage text in transcribedimage text in transcribed

. . . Create a balance sheet as of December 31st, 2014 and a cash flow statement for the three months ending 12/31/14 using the following information. Assume bills are paid in current month unless otherwise indicated. Take home salary received each week is $450 Utility (electric/gas/water) bills in October were $165, November $195, and December $200. Bought presents and clothes for $110 in September, $140 in October, $350 in November. o All purchases we're on credit and paid in the following month. Credit limit on credit card is $3000. Interest earned on savings during October, November, and December was $5 Balance in savings account 12/31/14 was $0. Car payment of $250 was paid each month. Car loan outstanding at 12/31/14 is $6000. Car has depreciated $4000 bye 12/31/14. Paid car and home insurance for $330 on October 1. Mortgage is $700 per month. Borrowed a friend's leaf blower for a week in November. 401k value per 12/31/14 statement is $2000. Own home which was purchased for $100,000 (mortgage outstanding at 12/31/14 is $87,000). Withdrew $50 from ATM machine on December 12. Received cash gift of $75 in December and spent it on miscellaneous items. Car was purchased for $10,000 last year. Furniture, clothing, etc. worth approximately $20,000. Phone bill was $30 per month. Spending at supermarkets and restaurants was $1200 for October, November, and December Flew to visit family for the holidays, airfare was $340. Miscellaneous expenses for October through December were $300 (gas for car, haircuts, newspapers, etc.) Portion of dentist bill not paid by insurance was $60 in November. Balance Sheet as of 12/31/14 ASSETS LIABILITIES $ $ $ $ $ $ $ $ $ $ $ $ $ $ NET WORTH S TOTAL $ TOTAL FA Cash Flow - 4th Quarter 2014 Sources of Cash $ $ $ $ S $ $ $ A $ $ $ Uses of Cash $ $ $ $ $ $ $ $ $ S Cash generated (used) $ . . . Create a balance sheet as of December 31st, 2014 and a cash flow statement for the three months ending 12/31/14 using the following information. Assume bills are paid in current month unless otherwise indicated. Take home salary received each week is $450 Utility (electric/gas/water) bills in October were $165, November $195, and December $200. Bought presents and clothes for $110 in September, $140 in October, $350 in November. o All purchases we're on credit and paid in the following month. Credit limit on credit card is $3000. Interest earned on savings during October, November, and December was $5 Balance in savings account 12/31/14 was $0. Car payment of $250 was paid each month. Car loan outstanding at 12/31/14 is $6000. Car has depreciated $4000 bye 12/31/14. Paid car and home insurance for $330 on October 1. Mortgage is $700 per month. Borrowed a friend's leaf blower for a week in November. 401k value per 12/31/14 statement is $2000. Own home which was purchased for $100,000 (mortgage outstanding at 12/31/14 is $87,000). Withdrew $50 from ATM machine on December 12. Received cash gift of $75 in December and spent it on miscellaneous items. Car was purchased for $10,000 last year. Furniture, clothing, etc. worth approximately $20,000. Phone bill was $30 per month. Spending at supermarkets and restaurants was $1200 for October, November, and December Flew to visit family for the holidays, airfare was $340. Miscellaneous expenses for October through December were $300 (gas for car, haircuts, newspapers, etc.) Portion of dentist bill not paid by insurance was $60 in November. Balance Sheet as of 12/31/14 ASSETS LIABILITIES $ $ $ $ $ $ $ $ $ $ $ $ $ $ NET WORTH S TOTAL $ TOTAL FA Cash Flow - 4th Quarter 2014 Sources of Cash $ $ $ $ S $ $ $ A $ $ $ Uses of Cash $ $ $ $ $ $ $ $ $ S Cash generated (used) $

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial management theory and practice

Authors: Eugene F. Brigham and Michael C. Ehrhardt

13th edition

1439078106, 111197375X, 9781439078105, 9781111973759, 978-1439078099

More Books