Analyze the beginning and ending cash positions from your statement of cash flows for each of the
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 2 Cash Flow Report Item Quarter 1 3 Beginning Cash Balance 5 Revenues 0 Quarter 2 Quarter 3 Quarter 4 674,500 1,090,672 768,128 Quarter 5 Quarter 6 1,469,942 1,487,857 Receipts and Disbursements from Operating Activities 0 6 Rebates 0 483,650 9,800 7 Production 0 211,779 313,073 832,400 1,199,600 17,000 24,150 420,016 2,041,850 2,243,550 41,450 627,812 45,550 630,005 8 Research and Development 90,000 0 30,000 257,406 0 0 9 Quality Costs 0 49,421 42,317 26,096 31,857 29,203 10 System Improvement Costs 0 5,000 100,000 1,220,250 693,297 169,038 11 - Advertising 12 - Internet Marketing Expenses 0 89,397 125,678 183,859 183,859 183,859 0 3,000 3,000 22,620 76,239 74,133 13 Sales Force Expense 14 Store Expense 15 Marketing Research 16 Shipping 17 Excess Capacity Cost 18 Income Taxes 19 + Interest Income 20 Interest Charges 0 39,665 82,638 127,608 196,598 192,292 200,000 198,000 196,000 207,000 136,000 136,000 0 15,000 15,000 15,000 15,000 15,000 0 6,416 10,238 13,781 21,824 23,622 0 0 0 0 0 21,187 0 0 0 0 0 0 4,500 0 0 0 0 0 0 0 0 0 0 0 30 31 + Borrow Emergency Loan 32 33 21+ Other Income 22 Other Expenses 23 = Net Operating Cash Flow 24 25 Fixed Production Capacity 26 = Total Investing Activities 27 28 Increase in Common Stock 29 + Borrow Conventional Loan Repay Conventional Loan 0 0 0 0 0 0 0 0 0 0 0 0 -285,500 -143,828 -102,544 -1,318,186 17,915 723,660 Investing Activities 240,000 240,000 240,000 240,000 720,000 720,000 480,000 0 0 480,000 0 0 Financing Activities 1,500,000 500,000 500,000 2,500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Repay Emergency Loan Deposit 3 Month Certificate 34 + Withdraw 3 Month Certificate 35 = Total Financing Activities 36 Cash Balance, End of Period Cash Flow 0 0 0 0 0 0 300,000 0 0 0 0 0 0 300,000 0 0 0 0 1,200,000 800,000 674,500 1,090,672 500,000 2,500,000 0 0 768,128 1,469,942 1,487,857 2,211,517 Verification Details (+ Ready 89% 1 2 Cash Flow Report Item Quarter 1 3 Beginning Cash Balance 5 Revenues 0 Quarter 2 Quarter 3 Quarter 4 674,500 1,090,672 768,128 Quarter 5 Quarter 6 1,469,942 1,487,857 Receipts and Disbursements from Operating Activities 0 6 Rebates 0 483,650 9,800 7 Production 0 211,779 313,073 832,400 1,199,600 17,000 24,150 420,016 2,041,850 2,243,550 41,450 627,812 45,550 630,005 8 Research and Development 90,000 0 30,000 257,406 0 0 9 Quality Costs 0 49,421 42,317 26,096 31,857 29,203 10 System Improvement Costs 0 5,000 100,000 1,220,250 693,297 169,038 11 - Advertising 12 - Internet Marketing Expenses 0 89,397 125,678 183,859 183,859 183,859 0 3,000 3,000 22,620 76,239 74,133 13 Sales Force Expense 14 Store Expense 15 Marketing Research 16 Shipping 17 Excess Capacity Cost 18 Income Taxes 19 + Interest Income 20 Interest Charges 0 39,665 82,638 127,608 196,598 192,292 200,000 198,000 196,000 207,000 136,000 136,000 0 15,000 15,000 15,000 15,000 15,000 0 6,416 10,238 13,781 21,824 23,622 0 0 0 0 0 21,187 0 0 0 0 0 0 4,500 0 0 0 0 0 0 0 0 0 0 0 30 31 + Borrow Emergency Loan 32 33 21+ Other Income 22 Other Expenses 23 = Net Operating Cash Flow 24 25 Fixed Production Capacity 26 = Total Investing Activities 27 28 Increase in Common Stock 29 + Borrow Conventional Loan Repay Conventional Loan 0 0 0 0 0 0 0 0 0 0 0 0 -285,500 -143,828 -102,544 -1,318,186 17,915 723,660 Investing Activities 240,000 240,000 240,000 240,000 720,000 720,000 480,000 0 0 480,000 0 0 Financing Activities 1,500,000 500,000 500,000 2,500,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Repay Emergency Loan Deposit 3 Month Certificate 34 + Withdraw 3 Month Certificate 35 = Total Financing Activities 36 Cash Balance, End of Period Cash Flow 0 0 0 0 0 0 300,000 0 0 0 0 0 0 300,000 0 0 0 0 1,200,000 800,000 674,500 1,090,672 500,000 2,500,000 0 0 768,128 1,469,942 1,487,857 2,211,517 Verification Details (+ Ready 89%
Expert Answer:
Related Book For
Fundamental financial accounting concepts
ISBN: 978-0078025365
8th edition
Authors: Thomas P. Edmonds, Frances M. Mcnair, Philip R. Olds, Edward
Posted Date:
Students also viewed these finance questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
Analyze the beginning and ending cash positions from your statement of cash flows from quarter six (Q6) for each of the following: cash flow from operating activities cash flow from investing...
-
11. The mortgage on your house is ten years old. It required monthly payments of $1000, had an original term of 30 years, and had an interest rate of 12% (APR). During the past ten years, interest...
-
To compute trend percents the analyst should: A. Select a base period, assign each item in the base period statement a weight of 100%, and then express financial numbers from other periods as a...
-
Why do you think having the Mission Control central to the marketing department is important to Gatorade?
-
Suppose that the per hour worked form of the production function for an economy is given by the depreciation rate is 10%, the investment rate is 20%, and the growth rate of labor hours is 2%. a. Find...
-
Obtain an annual report of a trading company (see References at the end of this chapter). Produce a vertical and horizontal analysis of the company's income statement, balance sheet and cash flow...
-
Following are the amounts of the assets and liabilities of Oriental Travel Agency at December 31, 2014, the end of the current year, and its revenue and expenses for the year. The retained earnings...
-
Passiflorace Bhd just signed an agreement to lease an embroidery machine as below: Date of arrangement Lease term Fair Value of machine Lease rental payment per annum Lease term Estimated residual...
-
Winners of the Georgia Lotto drawing are given the choice of receiving the winning amount divided equally over 18 years or as alump-sum cash option amount. The cash option amount is determined by...
-
Determine the minimum value of Av. 2N5459 has values of minimum gmo = 2 mS at VGs(off) = -2 V and maximum gmo = 6 ms at VGS(off) = -8 V. +40 V www R 12 www R 3 RD 8.2 2N5459 rs 2.2 Rs - 2.7 RL...
-
Carmen Camry operates a consulting firm called Help Today, which began operations on December 1. On December 31, the company's records show the following selected accounts and amounts for the month...
-
2 i. What are the values of A, B, and C in the table below, that gives the probability mass function of X? X 2 3 4 5 6 7 89 10 11 12 1 1 P(X = x) 36 13 12 2010 61 5 3 ABC 36 36 36 23 1 36 (3 marks)...
-
Draw out the mechanism for the reaction involving butan-2-one with one of the two reagents shown below: primary amine or alcohol. You only need to show one mechanism. To assist you, there are two...
-
Xorrec supplior finds that it costs $ 8 5 0 to roast and package 1 0 0 pounds of coffee in a day and $ 2 8 5 0 to produce 5 0 0 pounds of coffee in a day. Assume that the cost function is linear....
-
Explain in detail to Juan all of the stages in an effective recruitment and selection (Talent Acquisition) program. In addition to your explanation, provide a list of three specific issues that may...
-
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
-
Due to unforeseen circumstances, you have to take out a student loan for your senior year. Which one of the following loans should you choose? a. A loan with a nominal 10 percent interest rate with...
-
Find the value at time 50 of the set of end-of-year cash flows shown, if the appropriate rate of return is 11 percent per year: a. $179,255 b. $1,255,000 c. $33,079,044 d. $6,106,191,094 Year(s) 1...
-
Sharon Livingston Manufacturing Company uses the following budgets: Balance Sheet, Capital Expenditure, Cash, Direct Labor, Direct Materials, Income Statement, Manufacturing Overhead, Production,...
Study smarter with the SolutionInn App