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...
-
Consider the network in figure. The two-port network is a hybrid model for basic transistor. Determine the voltage gain of the entire network, V2/VS, if a source VS with internal resistance R1 is...
-
Let \(\left\{X_{n}ight\}_{n=1}^{\infty}\) and \(\left\{Y_{n}ight\}_{n=1}^{\infty}\) be sequences of independent random variables. Suppose that \(Y_{n}\) is a \(\operatorname{BETA}\left(\alpha_{n},...
-
What is the formula for calculating the factory overhead applied rate?
-
Seventeen years ago, the Archer Corporation borrowed $6,500,000. Since then, cumulative inflation has been 65 percent (a compound rate of approximately 3 percent per year). a. When the firm repays...
-
10.Peartree Company provee la siguiente informacin (provides the following data:) BALANCE SHEET Dec 31, 20Y4 Dec 31, 20Y3 Cash $21,000 $18,000 Accounts receivable, net 31,000 35,000 Inventory 53,000...
-
Using Bayes decision rule, consider the decision analysis problem having the following payoff table (in units of thousands of dollars): (a) Which alternative should be chosen? What is the resulting...
-
PROBLEM 6 (6 marks) Convert the following NFA M3 to an equivalent REX using the algo- rithm taught in this course no other algorithm will be accepted. Start by introducing the new start state and the...
-
Jasmine Dayne ( 2 9 ) is filing as a single taxpayer. In 2 0 2 2 , she received income from the following sources: $ 3 9 , 0 0 0 in wages. Alimony payments totaling $ 1 4 , 3 2 8 . Her divorce was...
-
Consider two possible projects that are mutually exclusive: Project A: Benefit = $ 3 5 , 0 0 0 per year, Initial Cost = $ 2 5 , 0 0 0 in year 0 , life = 3 years Project B: Benefit = $ 3 0 , 0 0 0 per...
-
Discuss one revenue cycle risks and the applicable internal control that can be adopted. Explain Discuss three kinds of manufacturing processes and give example of each type.
-
(31) On January 2, current year, Kalahari Limited issued $1,000,000, 10-year bonds for $1,150,000. The bonds pay interest on June 30 and December 31. The interest rate is 10%. What is the carrying...
-
Calculate the target gapusing the following date: Product 1 target selling price is $30, target profit is 25% margin and the estimated cost is $25.20.
-
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2018 and 2017 2018 2017 Assets Cash $ 87,500 $ 44,000 Accounts receivable,...
-
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...
-
What are decreasing-cost industries?
-
What is productive efficiency?
-
In long-run equilibrium under perfect competition, price does not equal which of the following? a. Long-run marginal cost b. Minimum average total cost c. Average fixed cost d. Marginal revenue e....
Study smarter with the SolutionInn App