
Concept explainers
Case summary:
Company P manufacturing is the manufacturer of cardboard boxes. The company decided to put all its receivables in one shoebox and all payables in others. Due this disorganized system, the company employed Person X. The company has a cash balance of $240,000 and planning to purchase a new box folding in the fourth quarter at a cost of $445,000. The purchase of machinery is in cash mode because of offered discounts. It needs to maintain minimum cash balance of $100,000.
Characters in the case:
- Company P: The manufacturer
- Person X: The new employee
To determine: The cash balance and short term financial plans of P manufacturers.
Introduction:
Cash budget is the numerical expression of cash inflows and outflows of the company during a specific period.

Explanation of Solution
Adequate information:
The Company’s sales during the four quarters are $1,240,000, $1, 370, 000, $1,450,000. The projected sales for Q1 are $1,290,000 and accounts receivables period of 53 days and accounts receivables amounts to $630,000 and 20% of accounts receivables are irrecoverable,
P manufacturing orders 50 percent of next quarter's projected gross sales in the current quarter, and suppliers are paid in 42 days. Wages, taxes, and other costs are 30% of gross sales. Interest is $130,000 and the bank pays 1.5% on short-term borrowings and 1% on deposits.
When the P Company decides to offer a discount of
Compute the net sales after discount:
Determine the cash balance when the company maintains minimum cash balance of $100,000:
Note: Since the sale value is reduced and the accounts receivables reduced to 36 days, the cash balance will be calculated on the reduced sale value.
Compute the net
A/R at beginning of Qcollected | $504,000.00 | $494,016.00 | $521,904.00 | $545,808.00 |
Sales collection incurrent Q | $741,024.00 | $782,856.00 | $818,712.00 | $866,520.00 |
Purchases last Q paidthis Q | –$289,333.33 | –$305,666.67 | –$319,666.67 | –$338,333.33 |
Purchase for next Q paidthis Q | –$349,333.33 | –$365,333.33 | –$386,666.67 | –$344,000.00 |
Expenses | –$372,000.00 | –$393,000.00 | –$411,000.00 | –$435,000.00 |
Interest and dividends | –$130,000.00 | –$130,000.00 | –$130,000.00 | –$130,000.00 |
Outlay | –$445,000.00 | |||
Net cash inflow | $104,357.33 | $82,872.00 | $93,282.67 | –$280,005.33 |
Working notes:
A/R at beginning of Q collected:
Q1 0.80 of current sales and remaining quarters be
Accounts receivable from current quarter sales:
Q1=
Purchases last Q paid this Q :
Purchase for next Q paid this Q:
Note: Refer excel for above cash budget calculation
Compute the net cash balance of each quarter:
Particulars | Q1 | Q2 | Q3 | Q4 |
Beginning cash balance | $240,000.00 | $344,357.33 | $427,229.33 | $520,512.00 |
Net cash inflow | $104,357.33 | $82,872.00 | $93,282.67 | ($280,005.33) |
Ending cash balance | $344,357.33 | $427,229.33 | $520,512.00 | $240,506.67 |
Minimum cash balance | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 |
Cumulative surplus(deficit) | $244,357.33 | $327,229.33 | $420,512.00 | $140,506.67 |
Compute short-term financial plan:
Particulars | Q1 | Q2 | Q3 | Q4 |
Target cash balance | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 |
Net cash inflow | $104,357.33 | $82,872.00 | $93,282.67 | –$280,005.33 |
New short-term investments | –$105,757.33 | –$85,329.57 | –$96,593.54 | 0 |
Income on short-terminvestments (WN:1) | $1,400.00 | $2,457.57 | $3,310.87 | $4,276.80 |
Short-term investments sold | $0 | $0 | $0 | $275,728.53 |
New short-term borrowing | $0 | $0 | $0 | $0 |
Interest on short-term borrowing | $0 | $0 | $0 | $0 |
Short-term borrowing repaid | $0 | $0 | $0 | $0 |
Ending cash balance | $100,000.00 | $100,000.00 | $100,000.00 | $100,000.00 |
Minimum cash balance | –$100,000.00 | –$100,000.00 | –$100,000.00 | –$100,000.00 |
Cumulative surplus (deficit) | $0 | $0 | $0 | $0 |
Beginning short-term investments | $140,000.00 | $245,757.33 | $331,086.91 | $427,680.44 |
Ending short-term investments(WN:2) | $245,757.33 | $331,086.91 | $427,680.44 | $151,951.91 |
Beginning short-term debt | $0 | $0 | $0 | $0 |
Ending short-term debt | $0 | $0 | $0 | $0 |
Working notes: 1
Compute interest on each quarter and net cash cost:
Quarter | Excess funds | Interestrate | Interest paid |
(or received) | |||
1 | $140,000 | 0.01 | $1,400 |
2 | $245,757 | 0.01 | $2,458 |
3 | $331,086.91 | 0.01 | $3,310.87 |
4 | $427,680.44 | 0.01 | $4,276.80 |
Net cashcost | $11,445 |
Working notes: 2
Q1 | Q2 | Q3 | Q4 |
$140,000 | $245,757.33 | $331,086.90 | $427680.44 |
$105,757.33 | $85,329.57 | $96,593.54 | ($275,728.53) |
$245,757.33 | $331,086.90 | $427,680.44 | $151,951.91 |
Hence, the net cash cost is $11,445.
To determine: The effective annual rate
Compute the effective interest rate:
Hence, the effective annual rate is 13.01%.
Want to see more full solutions like this?
Chapter 18 Solutions
Fundamentals of Corporate Finance
- Light Sweet Petroleum, Inc., is trying to evaluate a generation project with the following cash flows. If the company requires a return of 12 percent on its investments, what is the project's NPV? What are the IRRS for the project? Year 0 $ (45,000,000) Year 1 $ 71,000,000 Year 2 $ (15,000,000) Required return 12% Complete the following analysis. Do not hard code values in your calculations. Use a "Guess" of .99 to calculate the higher IRR and -.99 to calculate the lower IRR. You must use the built-in Excel functions to answer this question. NPV Higher IRR Lower IRRarrow_forwardBethesda Mining Company reports the following balance sheet information for 2021 and 2022: Assets Current assets 2021 BETHESDA MINING COMPANY Balance Sheets as of December 31, 2021 and 2022 Liabilities and Owners' Equity Current liabilities Accounts payable Notes payable 2021 $ 190,422 85,520 2022 Cash Accounts receivable Inventory $ 47,858 61,781 124,912 $ 60,783 82,139 190,747 Total $ 275,942 Total $ 234,551 $ 333,669 Long-term debt $ 238,000 Owners' equity Fixed assets Common stock and paid-in surplus Accumulated retained earnings $ 217,000 161,656 Net plant and equipment Total assets $ 658,047 $ 589,628 $ 378,656 $ 892,598 $ 923,297 Total liabilities and owners' equity $ 892,598 Total 2022 $ 198,111 137,088 $ 335,199 $ 174,750 $ 217,000 196,348 $ 413,348 $ 923,297 Based on the balance sheets given, calculate the following financial ratios for each year: Calculate the following financial ratios for each year: a. Current ratio. Note: Do not round intermediate calculations and round…arrow_forwardMary decides to buy a Treasury note futures contract for delivery of $100,000 face amount in September, at a price of 120′24.0. At the same time, Eric decides to sell a Treasury note futures contract if he can get a price of 120′24.0 or higher. The exchange, in turn, agrees to sell one Treasury note contract to Mary at 120′24.0 and to buy one contract from Eric at 120′24.0. The price of the Treasury note decreases to 120′10.5. Calculate Eric's balance on margin account. Assume that initial margin is $1,890. Please note that loss should be entered with minus sign. Round the answer to two decimal places.arrow_forward
- Don't used hand raiting and don't used Ai solutionarrow_forward(2x76m A = + S) Waterfront Inc. wishes to borrow on a short-term basis without reducing its current ratio below 1.25. At present its current assets and current liabilities are $1,600 and $1,000 respectively. How much can Waterfront Inc. borrow?arrow_forwardExpected Standard Stock Return Beta Deviation A B 12% 16 0.75 1.25 28% 37 The market index has a standard deviation of 22% and the risk-free rate is 9%. Required: a. What are the standard deviations of stocks A and B? b. Suppose that we were to construct a portfolio with proportions: Stock A Stock B T-bills 0.25 0.50 0.25 Compute the expected return, beta, nonsystematic standard deviation, and standard deviation of the portfolio. Complete this question by entering your answers in the tabs below. Required A Required B What are the standard deviations of stocks A and B? Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Stock A 0.33 % Stock B 0.46 %arrow_forward
- Don't used hand raiting and don't used Ai solutionarrow_forwardCould you explain what are the Biblical principles researchers that can follow to mitigate researcher bias? How to use of Biblical ethics to synthesize the literature to avoid misrepresentation of the literature? How researchers can demonstrate Biblical ethics when collecting and analyzing data?arrow_forwardThe manager of company A is thinking about adding an air conditioner to the office. The AC will cost $1630 to buy and install. The manager plans to use the AC for 5 years and each year's depreciation rate is 18% of the purchase price. The manager expects to sell the AC in 5 years for $880.The tax rate is 15% and the company's WACC is 15%. If the manager considers this purchase of AC as an investment, what is the NPV (keep two decimal places and assume that the AC will not affect the operations of the company)?arrow_forward
- Problem 5-5 Calculating IRR A firm has a project with the following cash flows: Year Cash Flow 0 -$27,700 1 23 11,700 14,700 10,700 The appropriate discount rate is 18 percent. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR %arrow_forwardCould you help to explain: How researchers can demonstrate Biblical ethics when conducting a literature review? How researchers can demonstrate Biblical ethics when communicating with a research team or university committee? How researchers can demonstrate Biblical ethics when recruiting participants. Provide Biblical and/or scholarly support for all assertions?arrow_forwardCould you please help explain what is the Biblical ethics in research? How do they establish a firm ethical foundation based on Biblical principles? What should they do to reduce the researcher bias as well as misrepresenting the literature and study findings? How Christians would like to ensure of being obedient to God in the research and study conduct?arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
