Rework the budget by using your suggested minimum cash balance ($60,000). Also include any interest from borrowing
Fantastic news! We've Found the answer you've been seeking!
Question:
Rework the budget by using your suggested minimum cash balance ($60,000). Also include any interest from borrowing and investing.
Need help with the cash budget part - please include formulas.
Transcribed Image Text:
Collections Worksheet Sales Collections Cash 30-days 60-days Rate of Credit Sales Collected Total Cash Collections Disbursements Worksheet Purchases Payments Salaries Interest Other expenses Taxes New Computer Total Cash Disbursements Net Cash Flows NOV 750,000 825,000 Rate 30% 40% 30% 98% DEC 75% JAN 350,000 300,000 648,900 JAN FEB 0 335,500 FEB MAR 0 APR 298,000 250,000 400,000 500,000 105,000 90,000 75,000 120,000 150,000 157,500 180,000 187,500 210,000 323,400 137,200 117,600 98,000 156,800 196,000 205,800 235,200 220,500 242,550 102,900 88,200 73,500 117,600 147,000 154,350 176,400 469,750 295,500 306,200 380,300 471,100 MAR APR MAY 225,000 187,500 300,000 375,000 393,750 450,000 262,500 225,000 187,500 300,000 375,000 393,750 60,000 60,000 60,000 60,000 60,000 60,000 4,000 4,000 4,000 4,000 4,000 4,000 9,000 9,000 9,000 9,000 9,000 145,000 25,000 9,000 145,000 0 0 405,500 373,000 313,400 171,750 (110,000) (66,800) MAY JUN 0 448,000 JUL 525,000 600,000 625,000 700,000 JUN JUL AUG 532,800 577,050 631,400 0 468,750 525,000 450,000 468,750 60,000 60,000 4,000 4,000 9,000 9,000 636,750 523,000 (67,700) (165,650) 9,800 AUG SEP 0 35,300 SEP OCT 217,500 240.000 270,000 245,000 274,400 284,200 313,600 183,750 205,800 213,150 725,000 800,000 (111,600) NOV OCT 675,650 730,000 796,750 543,750 600,000 675,000 525,000 543,750 600,000 60,000 60,000 60,000 4,000 4,000 4,000 9,000 9,000 9,000 145,000 0 0 NOV 541,750 743,000 616,750 673,000 58,900 DEC 0 900,000 DEC 300,000 675,000 60,000 4,000 9,000 145,000 0 893,000 57,000 (96,250) Collections Worksheet Sales Collections Cash 30-days 60-days Rate of Credit Sales Collected Total Cash Collections Disbursements Worksheet Purchases Payments Salaries Interest Other expenses Taxes New Computer Total Cash Disbursements Net Cash Flows NOV 750,000 825,000 Rate 30% 40% 30% 98% DEC 75% JAN 350,000 300,000 648,900 JAN FEB 0 335,500 FEB MAR 0 APR 298,000 250,000 400,000 500,000 105,000 90,000 75,000 120,000 150,000 157,500 180,000 187,500 210,000 323,400 137,200 117,600 98,000 156,800 196,000 205,800 235,200 220,500 242,550 102,900 88,200 73,500 117,600 147,000 154,350 176,400 469,750 295,500 306,200 380,300 471,100 MAR APR MAY 225,000 187,500 300,000 375,000 393,750 450,000 262,500 225,000 187,500 300,000 375,000 393,750 60,000 60,000 60,000 60,000 60,000 60,000 4,000 4,000 4,000 4,000 4,000 4,000 9,000 9,000 9,000 9,000 9,000 145,000 25,000 9,000 145,000 0 0 405,500 373,000 313,400 171,750 (110,000) (66,800) MAY JUN 0 448,000 JUL 525,000 600,000 625,000 700,000 JUN JUL AUG 532,800 577,050 631,400 0 468,750 525,000 450,000 468,750 60,000 60,000 4,000 4,000 9,000 9,000 636,750 523,000 (67,700) (165,650) 9,800 AUG SEP 0 35,300 SEP OCT 217,500 240.000 270,000 245,000 274,400 284,200 313,600 183,750 205,800 213,150 725,000 800,000 (111,600) NOV OCT 675,650 730,000 796,750 543,750 600,000 675,000 525,000 543,750 600,000 60,000 60,000 60,000 4,000 4,000 4,000 9,000 9,000 9,000 145,000 0 0 NOV 541,750 743,000 616,750 673,000 58,900 DEC 0 900,000 DEC 300,000 675,000 60,000 4,000 9,000 145,000 0 893,000 57,000 (96,250)
Expert Answer:
Answer rating: 100% (QA)
To rework the budget and incorporate the suggested minimum cash balance of 60000 as well as interest from borrowing and investing we can start by calc... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting 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...
-
In this game, students fence off an area of the drill field and divide it up into a series of equally sized squares. (We will assume there are 500 such squares organized into a 20 by 25 matrix.) Each...
-
Determine the exact time from the first date to the second date. Use Table 10.1 . Assume the year is not a leap year unless otherwise indicated. April 18 to November 11 Days in Each Month 31 28 31 30...
-
If $4000 is deposited into an account paying 3% interest compounded annually and at the same time $2000 is deposited into an account paying 5% interest compounded annually, after how long will the...
-
Continuation of Exercise 5-1 Determine and E (X) and E(Y).
-
Use Newtons method to find all the solutions of the equation correct to eight decimal places. Start by drawing a graph to find initial approximations. -- .2 x + 1
-
If a '5 for 3' rights issue is made at 1.90 per share, how much would a shareholder who owns 15,000 shares pay to the company to buy all the shares he is entitled to? a. 28,500 b. 17,100 c. 47,500 d....
-
The Hannam Company decided to change from the declining- balance method of depreciation to the straight- line method effective 1 January 20X7. The following information was provided: The company has...
-
Ole Fashion in Adents operates des deparments Man's Women's, and Acc Digamental operingecame des for the med quartir of the cut y (Ok the on to view is dan) What should the company do now? Fast...
-
1. Who are the followers at Bluebird Care? 2. In what way is followership related to the mission of the agency? Do Robin and her managers recognize the importance of followership? Explain. 3. Using...
-
A square footing is 2m x 2m in plan. The soil support the foundation has the following properties: o'=25, c'= 20 kN/m.y=18kN/m The depth of the footing (D) is 1.5m. Ground water table is at 0.5 m:...
-
The fixed cost of B ltd. is $20,000, variable costs are $16,000 and break-even point is $8,000. You are required to find the sales and net profit of B ltd.
-
Project manager told his boss in a meeting that "Cost estimates and budgets are ideally based upon elements of the WBS and are prepared at the work package level. But when the cost cannot be...
-
The subject of your individual assignment is "Seven Quality Control Tools." These tools are listed here. 1. Data figures, 2. Pareto analysis, 3. Cause and effect analysis, 4. Trend analysis, 5....
-
A 30-year-old worker plans to retire at age 65. He believes that $800,000 is needed to retire comfortably. How much should be deposited now at 8% compounded monthly to meet the $800,000 < retirement...
-
What do you mean by Hardware Software Interface? Give a concrete example. Define the two principle integrity rules for the relational model. Discuss why it is desirable to enforce these rules.
-
Rainbow Appliance Company has been in business for 10 years manufacturing and selling various household appliances. Four years ago Rainbow had an R&D breakthrough when the developed a new vacuum c...
-
Outline a general process applicable to most control situations. Using this, explain how you would develop a system to control home delivery staff at a local pizza shop.
-
Harold Conners (Social Security number 785-23-9873) lives at 13234 DeMilo Drive, Houston, TX 77052, and is self-employed for 2012. He estimates his required annual estimated tax payment for 2012 to...
-
Amy is a calendar-year taxpayer reporting on the cash basis. Please indicate how she should treat the following items for 2012: a. She makes a deductible contribution to an IRA on April 15,...
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
The International Accounting Standards Board and the Financial Accounting Standards Board have replaced IAS 11 Construction Contracts and IAS 18 Revenue with IFRS 15. Requirement: With reference to...
-
A supermarket awards 100 points to customers for each 100 worth of purchases in a single transaction. The customers may then exchange 1,000 points for goods with a retail value of 60; the cost to the...
-
How does one account for investment property in accordance with IAS 40?
Study smarter with the SolutionInn App