Carefully study the following cash budget and determine the amount to be borrowed or repaid during...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Carefully study the following cash budget and determine the amount to be borrowed or repaid during each quarter, so that the company never ends a quarter with less than $50,000 cash on hand, and always repays as much debt as possible. There is no debt as of the beginning of the first quarter, and interest costs are assumed not significant in this analysis. Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to determine the right amounts to borrow and repay each quarter. Correct choices will result in the boxed areas turning green. Cash budget First Quarter Second Quarter Third Quarter Fourth Quarter Beginning cash $ 10,000 $ 52,500 $ 59,500 $ 62,500 Customer receipts 140,000 160,000 200.000 250,000 Available cash $ 150,000 212,500 $ 259,500 312,500 Less: disbursements Direct materials $ 28,000 $ 30,000 $ 41,000 $ 48,000 Direct labor 14,000 16,000 20,000 25,000 Factory overhead 13,500 14,000 15,000 17,000 SG&A 31,000 31,000 33,000 33,000 Other expense and tax 11,000 12,000 13,000 15,000 Equipment purchases 250,000 225,000 Total disbursements $ 97,500 $ 353,000 $ 122,000 $ 363,000 Cash surplus (deficit) $ 52,500 $ (140,500) $ 137,500 $ (50,500) Financing: Planned borrowing $ $ 200,000 $ $ 125,000 Question 1 Itranscript Planned repayment $ $ $ Ending cash balance $ 52,500 $ 59,500 $ (75,000) $ 62,500 $ 74,500 1 pts Alternatively, how much will be the minimum borrowing for the second quarter necessary to satisfy the $50,000 minimum cash required balance? Question 2 transcript Alternatively, how much will be the Maximum loan pay-off amount for the third quarter necessary to satisfy the $50,000 minimum cash required balance? Question 3 transcript 1 pts 1 pts Alternatively, how much will be the minimum borrowing for the fourth quarter necessary to satisfy the $50,000 minimum cash required balance? Question 4 transcript 1 pts Based on the Excel Cash Budget you prepared with all green cells on, what is the loan balance at the end of fourth quarter? 250,000 Carefully study the following cash budget and determine the amount to be borrowed or repaid during each quarter, so that the company never ends a quarter with less than $50,000 cash on hand, and always repays as much debt as possible. There is no debt as of the beginning of the first quarter, and interest costs are assumed not significant in this analysis. Use the pick lists associated with the boxed areas near the bottom of the spreadsheet to determine the right amounts to borrow and repay each quarter. Correct choices will result in the boxed areas turning green. Cash budget First Quarter Second Quarter Third Quarter Fourth Quarter Beginning cash $ 10,000 $ 52,500 $ 59,500 $ 62,500 Customer receipts 140,000 160,000 200.000 250,000 Available cash $ 150,000 212,500 $ 259,500 312,500 Less: disbursements Direct materials $ 28,000 $ 30,000 $ 41,000 $ 48,000 Direct labor 14,000 16,000 20,000 25,000 Factory overhead 13,500 14,000 15,000 17,000 SG&A 31,000 31,000 33,000 33,000 Other expense and tax 11,000 12,000 13,000 15,000 Equipment purchases 250,000 225,000 Total disbursements $ 97,500 $ 353,000 $ 122,000 $ 363,000 Cash surplus (deficit) $ 52,500 $ (140,500) $ 137,500 $ (50,500) Financing: Planned borrowing $ $ 200,000 $ $ 125,000 Question 1 Itranscript Planned repayment $ $ $ Ending cash balance $ 52,500 $ 59,500 $ (75,000) $ 62,500 $ 74,500 1 pts Alternatively, how much will be the minimum borrowing for the second quarter necessary to satisfy the $50,000 minimum cash required balance? Question 2 transcript Alternatively, how much will be the Maximum loan pay-off amount for the third quarter necessary to satisfy the $50,000 minimum cash required balance? Question 3 transcript 1 pts 1 pts Alternatively, how much will be the minimum borrowing for the fourth quarter necessary to satisfy the $50,000 minimum cash required balance? Question 4 transcript 1 pts Based on the Excel Cash Budget you prepared with all green cells on, what is the loan balance at the end of fourth quarter? 250,000
Expert Answer:
Related Book For
Financial Management for Public Health and Not for Profit Organizations
ISBN: 978-0132805667
4th edition
Authors: Steven A. Finkler, Thad Calabrese
Posted Date:
Students also viewed these accounting questions
-
What is main cause of differences in rules between sports played indoors versus played outdoors? game length equipment type number of players weather
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Describe the impact of mobile computing upon your business and project its impact in the future. Do the same for social media. In both cases, when considering impacts, consider how each technology...
-
Water enters the condenser (a heat exchanger) shown in Fig. 4.62 of a power plant at 70 8 F and leaves at 160°F. If the mass flux of the steam is 4 kg/s, determine the mass flux required for the...
-
Draw structural formulas for the following acids and esters: (a) 2-methylhexanoic acid (b) Pentyl butanoate (which has the odor of apricots) (c) Octyl acetate (which has the odor of oranges)
-
4M Inc. showed income tax on its tax return of \(\$ 4,800\) on December 31,2020 , and had a tax rate of \(25 \%\). If taxable income were equal to pretax GAAP income for 2020, determine the amount of...
-
Canon, a Japanese manufacturer of photographic equipment, decided against offshoring and kept its manufacturing and new product development processes in Japan, which has relatively high labor costs,...
-
Paid $1,900 in cash for advertising expense. Paid $1,500 in cash for supplies. (1) Select which two accounts are affected in each of the above transactions. (2&3) Post the above transactions into...
-
1. Look at the "before and "after" words for Account Category: Property, Plant, & Equipment, and select the correct statement below: A. All of the "before" and "after" words are correct. B. All of...
-
You are asked by ministers in government to use your knowledge of economics to make recommendations on ways in which the value of non-paid work in the home by (mainly) women can be calculated so that...
-
Define the following characteristics of business cycles: recurrence and persistence.
-
a. Define the term mainstream in relation to the discipline of economics. b. Why do you think that the neo-classical approach came to be the mainstream in economics? c. Look at the curriculum you are...
-
Desired consumption is \(C^{d}=2000+0.9 Y-\) \(100,000 r-G\), and desired investment is \(I^{d}=1000\) \(-45,000 r\). Real money demand is \(M^{d} / P=Y-6000 i\). Other variables are \(\pi^{e}=0.03,...
-
Define real shock and nominal shock. Give an example of each. What type of real shock do real business cycle economists consider the most important source of cyclical fluctuations?
-
What is the total overhead applied to Product U5? And X2? Show your work for both products: Expected Activity Estimated Activity Cost Activity Product Product Overhead Total Pools Measures U5 X2 Cost...
-
Which property determines whether a control is available to the user during run time? a. Available b. Enabled c. Unavailable d. Disabled
-
Can a profitable organization run out of money?
-
What is the essential issue upon which flexible bud-get variance analysis is based?
-
How could one assess the quality of a governments financial reporting?
-
\(106+75+94\) Use properties of real numbers and mental math to calculate the expression.
-
\(4 \times 72 \times 5\) Use properties of real numbers and mental math to calculate the expression.
-
\(43+62+17\) Use properties of real numbers and mental math to calculate the expression.
Study smarter with the SolutionInn App