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, Tenth Standard Edition
- Judy Baresford, the store manager of Comfort Futons, noticed that the amount of time the two bookkeepers were spending on accounts receivable, accounts payable, and cash receipts was increasing due to the stores increase in sales. A friend of Judys who is also a store manager suggested that she might want to have some special journals designed that would reduce the amount of work involved in the day-to-day bookkeeping at her store. Judy approached Jon Fortner and Sue Stavio, the bookkeepers, and asked them to come up with a proposal for special journals. During lunch, Jon told Sue he thought designing special journals would be a lot of work and it was not in his job description. Sue told him not to worry because she would just copy pages of special journals from her accounting textbook and they could submit these journals as their own design. Jon liked the idea and they agreed to meet the next night, scan the journals into Word, and submit them to Judy the following morning. 1. Do you think Sues suggestion is unethical? Why or why not? 2. In using the generic special journals from Sues accounting textbook, what possible problems can you foresee? 3. If you were Judy, how would you respond to Sue and Jons plan?arrow_forwardConsider the following conversation between Gary Means, manager of a division that produces industrial machinery, and his controller, Donna Simpson, a certified management accountant and certified public accountant: Gary: Donna, we have a real problem. Our operating cash is too low, and we are in desperate need of a loan. As you know, our financial position is marginal, and we need to show as much income as possibleand our assets need bolstering as well. Donna: I understand the problem, but I dont see what can be done at this point. This is the last week of the fiscal year, and it looks like well report income just slightly above breakeven. Gary: I know all this. What we need is some creative accounting. I have an idea that might help us, and I wanted to see if you would go along with it. We have 200 partially finished machines in process, about 20% complete. That compares with the 1,000 units that we completed and sold during the year. When you computed the per-unit cost, you used 1,040 equivalent units, giving us a manufacturing cost of 1,500 per unit. That per-unit cost gives us cost of goods sold equal to 1.5 million and ending work in process worth 60,000. The presence of the work in process gives us a chance to improve our financial position. If we report the units in work in process as 80% complete, this will increase our equivalent units to 1,160. This, in turn, will decrease our unit cost to about 1,345 and cost of goods sold to 1.345 million. The value of our work in process will increase to 215,200. With those financial stats, the loan would be a cinch. Donna: Gary, I dont know. What youre suggesting is risky. It wouldnt take much auditing skill to catch this one. Gary: You dont have to worry about that. The auditors wont be here for at least 6 to 8 more weeks. By that time, we can have those partially completed units completed and sold. I can bury the labor cost by having some of our more loyal workers work overtime for some bonuses. The overtime will never be reported. And, as you know, bonuses come out of the corporate budget and are assigned to overheadnext years overhead. Donna, this will work. If we look good and get the loan to boot, corporate headquarters will treat us well. If we dont do this, we could lose our jobs. Required: 1. Should Donna agree to Garys proposal? Why or why not? To assist in deciding, review the corporate code of ethics standards described in Chapter 1. Do any apply? 2. Assume that Donna refuses to cooperate and that Gary accepts this decision and drops the matter. Does Donna have any obligation to report the divisional managers behavior to a superior? Explain. 3. Assume that Donna refuses to cooperate; however, Gary insists that the changes be made. Now what should she do? What would you do? 4. Suppose that Donna is 63 and that the prospects for employment elsewhere are bleak. Assume again that Gary insists that the changes be made. Donna also knows that his supervisor, the owner of the company, is his father-in-law. Under these circumstances, would your recommendations for Donna differ?arrow_forwardJames Burrow is the loan officer for the National Bank of Dallas.National has a loan of $325,000 outstanding to Regional Delivery Service, a companyspecializing in delivering products of all types on behalf of smaller companies. National’scollateral on the loan consists of 25 small delivery trucks with an average original cost of$24,000.Burrow is concerned about the collectibility of the outstanding loan and whether thetrucks still exist. He therefore engages Samantha Altman, CPA, to count the trucks, usingregistration information held by Burrow. She was engaged because she spends most ofher time auditing used automobile and truck dealerships and has extensive specializedknowledge about used trucks. Burrow requests that Altman issue a report stating thefollowing:1. Which of the 25 trucks is parked in Regional’s parking lot on the night of June 30,2013.2. Whether all of the trucks are owned by Regional Delivery Service.3. The condition of each truck, using the guidelines of poor, good,…arrow_forward
- ABC Limited is a manufacturing firm with a workforce of more than 100 employees. Mr Peter has recently joined the firm as the account payable clerk. Miss Emma is the accounting department head, and she is concerned about the cash disbursement system. Therefore, she has asked Mr Peter to analyse the firm's cash disbursement system and identify the internal control weaknesses from the system. Following is the description of the cash disbursement system.In the temporary file, the account payable clerk receives the supplier's invoice and reconciles it with the purchase order. The accounts payable clerk records the purchase in the purchases journal from the clerk's computer terminal and records the liability by adding a record to accounts payable subsidiary ledger. The clerk then updates the inventory control and accounts payable control accounts in the general ledger. The purchases order and invoice are later filed in the department.Each day, the clerk visually searches the accounts…arrow_forwardABC Limited is a manufacturing firm with a workforce of more than 100 employees. Mr Peter has recently joined the firm as the account payable clerk. Miss Emma is the accounting department head, and she is concerned about the cash disbursement system. Therefore, she has asked Mr Peter to analyse the firm's cash disbursement system and identify the internal control weaknesses from the system. Following is the description of the cash disbursement system. In the temporary file, the account payable clerk receives the supplier's invoice and reconciles it with the purchase order. The accounts payable clerk records the purchase in the purchases journal from the clerk's computer terminal and records the liability by adding a record to accounts payable subsidiary ledger. The clerk then updates the inventory control and accounts payable control accounts in the general ledger. The purchases order and invoice are later filed in the department. Each day, the clerk visually…arrow_forwardAn accounting intern for a local CPA firm was reviewing the financial statements of a client in the electronics industry. The intern noticed that the client used the FIFO method of determining ending inventory and cost of goods sold. When she asked a colleague why the firm used FIFO instead of LIFO, she was told that the client used FIFO to minimize its income tax liability. This response puzzled the intern because she thought that LIFO would minimize income tax liability. Required: What would you tell the intern to resolve the confusion?arrow_forward
- A company has an external sales agency. The company allows the sales agency to incur and pay for all its expenses and approved asset purchases. The company has never transferred any tangible assets to the agency and created the agency by simply establishing an agency working capital fund of P40,000. Whenever the sales agency needs more working capital it transmits the receipts for what it has spent back to the main office which then sends cash back to the agency to cover the remitted items. Small amounts of merchandise inventory are sent to the agency for display and demonstration purposes. These items are transferred at cost. An operation such as the one descried above most closely resembles a Accounts payable subsidiary ledger Accounts receivable subsidiary ledger Voucher system Petty Cash systemarrow_forwardA company has an external sales agency. The company allows the sales agency to incur and pay for all its expenses and approved asset purchases. The company has never transferred any tangible assets to the agency and created the agency by simply establishing an agency working capital fund of P40,000. Whenever the sales agency needs more working capital it transmits the receipts for what it has spent back to the main office which then sends cash back to the agency to cover the remitted items. Small amounts of merchandise inventory are sent to the agency for display and demonstration purposes. These items are transferred at cost. An operation such as the one descried above most closely resembles a(n): Petty Cashsystem Accounts receivable subsidiaryledger Accounts payable subsidiaryledger Vouchersystemarrow_forwardA company has an external sales agency. The company allows the sales agency to incur and pay for all its expenses and approved asset purchases. The company has never transferred any tangible assets to the agency and created the agency by simply establishing an agency working capital fund of P40,000. Whenever the sales agency needs more working capital it transmits the receipts for what it has spent back to the main office which then sends cash back to the agency to cover the remitted items. Small amounts of merchandise inventory are sent to the agency for display and demonstration purposes. These items are transferred at cost. An operation such as the one descried above most closely resembles a(n): A. Accounts payable subsidiary ledgerB. Accounts receivable subsidiary ledgerC. Petty Cash systemD. Voucher systemarrow_forward
- You are an accounting student at Berkeley College and will not graduate for another year. But because of your excellent grades so far, you have been able to land a job in the purchasing department of a retailer. One of the purchasing agents in your company is negotiating for the receipt of a very large order of uninsured goods from a supplier. The purchasing agent is able to get a better deal on the goods if they are shipped FOB shipping point rather than FOB destination. The agent doesn’t know the difference between these two concepts. He also doesn’t understand why choosing one over the other should make any difference to the company. As a student of accounting at Berkeley College, you know well the difference between these 2 concepts and you know why one would be a better choice over the other in the case of uninsured goods. Please explain these two concepts in this discussion and tell the purchasing agent which shipping method is preferable and why.arrow_forwardYou are an assistant in the accounting department of Hasher Electronics, a small electronicsretailer. Hasher has a loan that requires the company to maintain a minimum cash balance of$125,000, as reported on its year-end balance sheet. Although Hasher has struggled in recent years,as of yesterday it looked as though Hasher would be able to meet this requirement. The cash balance in Hasher’s general ledger was $130,000 and the company’s credit manager was expecting toreceive a $30,000 electronic funds transfer that day on account from your biggest customer. Yourdepartment supervisor had been worried about meeting the loan requirement, so she had delayedmaking payments to Hasher’s suppliers for several days. But in anticipation of receiving the EFT,she decided yesterday to issue checks to suppliers totaling $15,000.It is now the last day of the fiscal year and your supervisor approaches you with a problem.Your big customer had backed out at the last minute, indicating it had “some…arrow_forwardSuppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Cost Product Cost/Period Cost 1. Factory supervisors' salaries 2. Heat, water, and power consumed in the factory 3. Materials used for boxing products for shipment overseas. Units are normally boxed. 4. Advertising costs 5. Workers' compensation insurance for factory employeearrow_forward
- Business Its Legal Ethical & Global EnvironmentAccountingISBN:9781305224414Author:JENNINGSPublisher:CengageCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,