Question: Please complete a projected balance sheet for the attached statement of cash flow 12 Month Cash Flow SCORE W FOR THE LIFE OF YOUR BUSINESS

Please complete a projected balance sheet for the attached statement of cash flow

12 Month Cash Flow SCORE W FOR THE LIFE OF YOUR BUSINESS TH Cash Flow (12 months) Enter Company Name Here Fiscal Year Begins: Jan-19 Pre- Total Startup Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 EST Item EST 191,544 176,544 207,519 236,694 238,969 275,944 308,169 339,644 363,369 398,544 432,154 463,684 494,659 176,544 Cash on Hand (beginning of month) 65,000 65,000 68,000 73,000 75,000 78,000 82,000 85,000 85,700 85,800 87,000 CASH RECEIPTS Cash Sales TOTAL CASH RECEIPTS Total Cash Available (before cash out) 90,000 939,500 90,000 939,500 0 65,000 65,000 68,000 73,000 75,000 78,000 82,000 85,000 85,700 85,800 87,000 191,544 241,544 272,519 304,694 311,969 350,944 386,169 421,644 448,369 484,244 517,954 550,684 584,659 1,116,044 CASH PAID OUT 10,000 11,000 11,000 13,000 16,000 20,000 22,000 24,000 26,000 28,000 30,000 34,000 245,000 Purchases (Inventory) Payroll expenses (taxes, etc.) 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 3,500 15,000 3,700 3,000 3,200 3,400 3,700 3,500 3,550 3,550 3,700 3,750 3,750 42,300 Supplies (office & oper.) Repairs & maintenance 2,000 2,600 2,300 300 4,250 4,000 3,700 3,250 3,365 3,545 3,250 3,100 38,360 Advertising 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 Rent 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 20,400 Telephone 200 200 200 200 200 200 200 200 200 200 200 200 2,400 Utilities 500 500 500 500 500 500 500 500 500 500 500 500 6,000 Insurance 250 250 250 250 250 250 250 250 250 250 250 250 3,000 Taxes (real estate, etc.) 375 375 375 375 375 375 375 375 375 375 375 375 4,500 388,960 SUBTOTAL 0 34,025 35,825 35,725 36,025 42,775 46,525 48,275 49,825 52,090 54,270 56,025 59,875 Other startup costs 15,000 15,000 Owners' Withdrawal 30,000 10,000 25,000 65,000 TOTAL CASH PAID OUT 15,000 34,025 35,825 65,725 36,025 42,775 46,525 58,275 49,825 52,090 54,270 56,025 84,875 468,960 Cash Position (end of month) 176,544 207,519 236,694 238,969 275,944 308,169 339,644 363,369 398,544 432,154 463,684 494,659 499,784 647,084 ESSENTIAL OPERATING DATA (non cash flow information) Bad Debt lend of month) 2,500 2,000 1,200 1.100 1200 1,200 1,200 1,200 1,200 2,000 2,500 3,000 25,800 12 Month Cash Flow SCORE W FOR THE LIFE OF YOUR BUSINESS TH Cash Flow (12 months) Enter Company Name Here Fiscal Year Begins: Jan-19 Pre- Total Startup Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 EST Item EST 191,544 176,544 207,519 236,694 238,969 275,944 308,169 339,644 363,369 398,544 432,154 463,684 494,659 176,544 Cash on Hand (beginning of month) 65,000 65,000 68,000 73,000 75,000 78,000 82,000 85,000 85,700 85,800 87,000 CASH RECEIPTS Cash Sales TOTAL CASH RECEIPTS Total Cash Available (before cash out) 90,000 939,500 90,000 939,500 0 65,000 65,000 68,000 73,000 75,000 78,000 82,000 85,000 85,700 85,800 87,000 191,544 241,544 272,519 304,694 311,969 350,944 386,169 421,644 448,369 484,244 517,954 550,684 584,659 1,116,044 CASH PAID OUT 10,000 11,000 11,000 13,000 16,000 20,000 22,000 24,000 26,000 28,000 30,000 34,000 245,000 Purchases (Inventory) Payroll expenses (taxes, etc.) 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 3,500 15,000 3,700 3,000 3,200 3,400 3,700 3,500 3,550 3,550 3,700 3,750 3,750 42,300 Supplies (office & oper.) Repairs & maintenance 2,000 2,600 2,300 300 4,250 4,000 3,700 3,250 3,365 3,545 3,250 3,100 38,360 Advertising 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 Rent 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 1,700 20,400 Telephone 200 200 200 200 200 200 200 200 200 200 200 200 2,400 Utilities 500 500 500 500 500 500 500 500 500 500 500 500 6,000 Insurance 250 250 250 250 250 250 250 250 250 250 250 250 3,000 Taxes (real estate, etc.) 375 375 375 375 375 375 375 375 375 375 375 375 4,500 388,960 SUBTOTAL 0 34,025 35,825 35,725 36,025 42,775 46,525 48,275 49,825 52,090 54,270 56,025 59,875 Other startup costs 15,000 15,000 Owners' Withdrawal 30,000 10,000 25,000 65,000 TOTAL CASH PAID OUT 15,000 34,025 35,825 65,725 36,025 42,775 46,525 58,275 49,825 52,090 54,270 56,025 84,875 468,960 Cash Position (end of month) 176,544 207,519 236,694 238,969 275,944 308,169 339,644 363,369 398,544 432,154 463,684 494,659 499,784 647,084 ESSENTIAL OPERATING DATA (non cash flow information) Bad Debt lend of month) 2,500 2,000 1,200 1.100 1200 1,200 1,200 1,200 1,200 2,000 2,500 3,000 25,800

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Required 1. Review the work that Sim prepared (Exhibit 1) to address the first assignment question in the case. Help Michelle and Caroline identify the mistakes and make the necessary corrections to...

the last three pictures are the amount and the numbers you need to use for calculation. thank you so much Left 0 Beforo: ation O pt Opt Right: 0" After Se ection Align Pano 1, Please complete the...

Financial Analysis Project Place your responses below each question in this document. For any question requiring computations, please show your work. When completed, upload this document using the...

Assignment Tasks In this assignment, students will have hands-on experience in developing an integrated framework for controlling, monitoring, and analysis of company financial information. In...

For any question requiring computations, please show your work. Following the instructions in the textbook on pp. 1-26 through 1-28, download: a. Amazons Form 10-K from the EDGAR website i. HTML and...

Hi! I have completed the exam, but am looking for someone to provide the answer key! Name: PENN ID: _________________________ ACCOUNTING 101 - 620, EXAM #1 Spring Semester, 2010 Instructions: 1. 2....

I need the answers to section IV on Walmart and Target ACCT 6305/SYSM 6337 Pre-Skilling Fall 2016 Table of contents Table of contents I. Basics of Financial Accounting...

Complete a Balance Sheet for the below statement of cash flows Please complete a projected balance sheet for the attached statement of cash flow 12 Month Cash Flow SCORE / FOR THE LIFE OF YOUR...

I'm trying to figure out how to formulate the balance sheet, income statement and statement of cash flows. I have attached my excel document for what we figured out on our own. I am particularly...

Assume that the first six months of 2021 have passed, and the Board requested that their accountant prepare an income statement for the first six months of 2021 showing how actual performance...

Two matrices A and B are said to be similar, written A ~ B, if there exists an invertible matrix S such that B = S-1 AS. Prove: (a) A ~ A (b) If A ~ B, then B ~ A. (c) If A ~ B ~ C, then A~ C.

Describe the implicit interest rate for a series of cash flows and a procedure for finding it.

If management decides to use an inventory method that will provide them with a higher net income, this is an example of: Group of answer choices Manipulation. Legitimate discretion. Aggressive...

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

Identify and control your anxieties

Understanding and Addressing Anxiety

2. Read a famous or familiar speech (such as Martin Luther Kings I Have a Dream speech), and create an outline for it. Can you follow a clear sequence of points? Do the subpoints support the speakers...