The most recent financial statements for Techno Toys are contained in Exhibit 1. Suppose that the controller
Question:
The most recent financial statements for Techno Toys are contained in Exhibit 1. Suppose that the controller has decided to seek out a term loan, which proceeds could be used to repay $650,000 of the firm's short-term notes. The particular note in question was due in March of the coming year. Part of the needed funds was expected to come from operations and another portion from the sale of fixed assets during January for $100,000 (accumulated depreciation on the assets is $150,000, while the original purchase price was $250,000).
In addition to paying off the short-term note in March, the controller felt the firm should increase its cash balance to a minimum level of $75,000. The controller hoped to be able to hold out with the firm's existing cash balance, $30,000, plus cash flow from operations, until March, when he intended to seek the long-term loan. The proceeds from the loan in conjunction with funds from operations would be used to clear up $650,000 in notes payable and reach the desired cash balance.
Sales estimates for the next seven months, as well as past monthly sales for the previous three months are presented in Exhibit 2.
Traditionally, Techno's sales have been 60% credit and 40% cash. Its gross profit margin is expected to improve from 25% to 30%. Of the credit sales, roughly half are collected one month after the sale and the remainder collected two months after the sale, with negligible bad debt losses. Purchases are approximately 75% of sales and are made one month in advance, with payment following in 60 days. Variable cash operating expenses (including selling costs, wages, advertising, and miscellaneous cash expenses) are 7% of sales and are paid in the month in which they are incurred. Fixed cash operating expenses are roughly $6,250 a month, with payment made in the same month. Taxes are paid quarterly (April for the quarter ended in March, and so on; assume ¼ of last year's taxes have not been paid.) based on estimated earnings for the quarter. Annual depreciation expense is $240,000 on the net assets remaining after the January 1, 2019 sale of fixed assets. Interest expense for the note payable is 10% and is payable quarterly in March and June. Interest on the outstanding long-term debt is at a rate of 7% and is paid semi-annually in June and December. The term loan is expected to carry an 8% rate, with interest payable semi-annually beginning in September and the entire principal amount due in five years.
- Create a monthly cash budget for the first 6 months of 2019.
- Create a balance sheet and income statement for the quarter ended March 31 and 6-months ended June 30. (You will have two balance sheets, one as of March 31 and the other as of June 30. You will have two income statements; one for the 3-months ended March 31 and the other for the 6-months ended June 30. (You DO NOThave to prepare monthly balance sheets and income statements)
- Based on your answer to question a., how much should Techno seek in additional long-term debt to pay off the $650,000 of the note and increase cash to $75,000 as of the end of March?
- How did Techno Toys get into its cash flow predicament?
Exhibit 1
| December 31, 2017 | December 31, 2018 |
|
|
|
Cash | 90,000 | 30,000 |
Accounts Receivable | 150,000 | 187,500 |
Inventory | 275,000 | 338,000 |
Total current assets | 515,000 | 555,500 |
Plant and Equipment | 3,335,000 | 4,172,400 |
Less: Accum. Depreciation | (1,100,000) | (1,250,000) |
Net Fixed Assets | 2,235,000 | 2,922,400 |
Total Assets | $2,750,000 | $3,477,900 |
|
|
|
Accounts Payable | 400,000 | 450,000 |
Short-term notes | 300,000 | 850,000 |
Accrued Expenses | 50,000 | 26,700 |
Total current liabilities | 750,000 | 1,326,700 |
|
|
|
Long-term Debt | 600,000 | 600,000 |
Common Stock $10 par | 1,000,000 | 1,000,000 |
Capital Surplus | 400,000 | 551,200 |
Total liabilities and net worth | $2,750,000 | $3,477,900 |
|
|
|
Income Statement for Year Ended December 31, 2018
Sales * | $3,000,000 |
Cost of goods sold | 2,250,000 |
Gross profit | 750,000 |
Operating expenses: |
|
Variable cash operating exp. | 210,000 |
Fixed cash operating exp. | 75,000 |
Depreciation | 150,000 |
Total operating expenses | 435,000 |
|
|
Net income before Int. & taxes | 315,000 |
Interest | 99,000 |
Net income before taxes | 216,000 |
Taxes @ 30% | 64,800 |
Net Income | $151,200 |
| |
* - includes 60% credit sales |
Exhibit 2
Sales data: 2018-2019
2018
October $250,000
November 250,000
December 375,000
2019 (projected)
January $225,000
February 225,000
March 225,000
April 250,000
May 275,000
June 250,000
July 245,000
Advanced Financial Accounting
ISBN: 978-0137030385
6th edition
Authors: Thomas Beechy, Umashanker Trivedi, Kenneth MacAulay