AudioFile Products Ltd. is a retailer of sound systems. The company is planning its cash needs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
AudioFile Products Ltd. is a retailer of sound systems. The company is planning its cash needs for the month of January 2024. In the past, AudioFile has had to borrow money during the post-Christmas season to offset a significant decline in sales. The statement of financial position showed the following at its fiscal year-end, December 31, 2023. Other information: Assets Current Cash Accounts receivable Inventory PPE, net a. Cash collection $20,000 280.000 126,000 426,000 i. December credit sales ii. % cash sales each month iii. %credit sales collected in same month $400,000 0% 30% 4,000,000 $4,426,000 iv. %credit sales collected in next month 70% Liabilities Current b. C. Inventory information January total sales $300,000 Operating loan $200,000 i. February total sales $250,000 Accounts payable 190,400 390,400 ii. Gross profit ratio all months 30% Non-current borrowings 3,000,000 iii. % purchases paid in cash same month 20% 3,390,400 iv. %inventory on hand needed for next month's sales 60% d. Shareholders' Equity Accounts payable at Dec. 31 all relate to inventory purchases and will be paid in full in January Common shares Retained earnings 70,000 965,600 e. Variable expenses as % of total sales $0 1.035.600 f. Fixed expenses $4,426,000 i. Depreciation, including any January budgeted PPE purchases $10,000 ii. Other fixed operating expenses, paid each month $20,000 g. Interest is paid monthly on opening balances of the operating loan and non- current debt. Interest rate per month: 1% h. Corporate income tax rate Income taxes are paid at the end of the fiscal year. i. Monthly cash dividends paid to shareholders j. Budgeted PPE purchases for January k. January repayments of principal on non-current debt 1. Desired minimum cash balance at end of January 20% $5,000 $0 $10,000 $20,000 m Maximum operating loan balance at end of January . Any excess cash will be used to pay down the operating loan. $200,000 Required: o. Any cash not able to be provided by the operating loan will be raised by issuing common shares. 1. Using a format the budget worksheet below (must), record the above information. ASSETS LIABILITIES S/H EQUITY Trans. Cash Acc. Rec. Invent. + PPE Op. Loan + Acc. Pay. + L/T Debt + Common Shares + Ret. Earn Desc. Cf. 20,000 280,000 126,000 4,000,000 200,000 190,400 3,000,000 70,000 965,600 a. b. C. d. e. f. g. h. i. j. k. 1. m. n. 0. Totals 2. Prepare a statement of financial position at January 31, 2024 and budgeted income statement, statement of changes in equity, and statement of cash flows for the month ended January 31, 2024. Show all calculations. For SCF purposes, assume the operating loan is part of cash and cash equivalents. 3. Apprise management of budgeted January operating loan needs and the dollar amount of any shares that may need to be issued. AudioFile Products Ltd. is a retailer of sound systems. The company is planning its cash needs for the month of January 2024. In the past, AudioFile has had to borrow money during the post-Christmas season to offset a significant decline in sales. The statement of financial position showed the following at its fiscal year-end, December 31, 2023. Other information: Assets Current Cash Accounts receivable Inventory PPE, net a. Cash collection $20,000 280.000 126,000 426,000 i. December credit sales ii. % cash sales each month iii. %credit sales collected in same month $400,000 0% 30% 4,000,000 $4,426,000 iv. %credit sales collected in next month 70% Liabilities Current b. C. Inventory information January total sales $300,000 Operating loan $200,000 i. February total sales $250,000 Accounts payable 190,400 390,400 ii. Gross profit ratio all months 30% Non-current borrowings 3,000,000 iii. % purchases paid in cash same month 20% 3,390,400 iv. %inventory on hand needed for next month's sales 60% d. Shareholders' Equity Accounts payable at Dec. 31 all relate to inventory purchases and will be paid in full in January Common shares Retained earnings 70,000 965,600 e. Variable expenses as % of total sales $0 1.035.600 f. Fixed expenses $4,426,000 i. Depreciation, including any January budgeted PPE purchases $10,000 ii. Other fixed operating expenses, paid each month $20,000 g. Interest is paid monthly on opening balances of the operating loan and non- current debt. Interest rate per month: 1% h. Corporate income tax rate Income taxes are paid at the end of the fiscal year. i. Monthly cash dividends paid to shareholders j. Budgeted PPE purchases for January k. January repayments of principal on non-current debt 1. Desired minimum cash balance at end of January 20% $5,000 $0 $10,000 $20,000 m Maximum operating loan balance at end of January . Any excess cash will be used to pay down the operating loan. $200,000 Required: o. Any cash not able to be provided by the operating loan will be raised by issuing common shares. 1. Using a format the budget worksheet below (must), record the above information. ASSETS LIABILITIES S/H EQUITY Trans. Cash Acc. Rec. Invent. + PPE Op. Loan + Acc. Pay. + L/T Debt + Common Shares + Ret. Earn Desc. Cf. 20,000 280,000 126,000 4,000,000 200,000 190,400 3,000,000 70,000 965,600 a. b. C. d. e. f. g. h. i. j. k. 1. m. n. 0. Totals 2. Prepare a statement of financial position at January 31, 2024 and budgeted income statement, statement of changes in equity, and statement of cash flows for the month ended January 31, 2024. Show all calculations. For SCF purposes, assume the operating loan is part of cash and cash equivalents. 3. Apprise management of budgeted January operating loan needs and the dollar amount of any shares that may need to be issued.
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 978-1259024900
9th canadian edition
Authors: Ray Garrison, Theresa Libby, Alan Webb
Posted Date:
Students also viewed these accounting questions
-
The following information is taken from the records of West End Distributors Inc. for the month ended May 31. Units Unit cost May 1 6 12 19 29 Purchase #1 Purchase #2 Purchase #3 ...
-
Explain why a safety net can save the life of a circus performer.
-
What is the role of the Public Company Accounting Over-sight Board in the audit of financial statements?
-
A rod meets its specifications if its diameter is between 0.98 and 1.02 inches. The mean diameter of a rod is 1 inch. What should the standard deviation of rods equal for 99 percent of rods to meet...
-
Nationwide Insurance developed a program to recruit new insurance agents by offering planning, training, and start-up financing to build self-sustaining agencies. These new agents would be...
-
Warranties Winslow Company sold 150 color laser copiers in 2010 for $4,000 apiece, together with a one-year warranty. Maintenance on each copier during the warranty period averages $300. (a) Prepare...
-
XYZ Inc., a well-known manufacturer of inflatable boats is considering a new project, a thickened inflatable boat. Thickened boat is of higher quality and double the price of the normal inflatable...
-
An act is said to be ultra vires Company when it is beyond the powers___________. A . Conferred on the Company by the Articles B . of the Company, C . of the Directors, D . of the Directors but not...
-
Air at 200 kPa and 400 K is contained in a 10 m insulated tank. The 80 kg weight is lowered by 2 m. The final pressure of air in the tank would be kJ kgK' kPa kJ [c=0.718- R = 0.287- kgk 9= 10 m/s]...
-
Q1 (4) The system as shown in Figure below contains a pump delivering oil of specific gravity 0.9 and kinematic viscosity 1104 m/s, to a hydraulic cylinder A pipe connects the pump and actuator has...
-
1) The displacement field in a material is: u= A(3x - y), v = Axy a) Calculate the strains (x, &y, and yxy) as function of x, y and A. b) Sketch the deformations of a differential (tiny) square...
-
Q3. Consider a bar of cross-section A and length L in fig.1. A uniform tensile load P is applied Tzx, Txy) and strain (&, ) to the two ends of the rod; find the state of stress (x, Ey, E, Vyz, Vzx,...
-
8. Two identical blocks are released from rest at the same height. Block A slides down a steeper ramp than Block B. Both ramps are frictionless. The blocks reach the same final height indicated by...
-
Is price discrimination always wrong? Are there situations where price discrimination is best for society? Support your answer.?
-
The following exercises are not grouped by type. Solve each equation. x610x -9
-
To test \(H_{0}: \sigma=50\) versus \(H_{1}: \sigma <50\), a random sample of size \(n=24\) is obtained from a population that is known to be normally distributed. (a) If the sample standard...
-
In Example 2 from Section 10.3, the quality-control engineer for M\&MMars tested whether the mean weight of fun-size Snickers was 20.1 grams. Suppose that the standard deviation of the weight of the...
-
(a) Determine the critical values for a right-tailed test of a standard population deviation with 18 degrees of freedom at \(\alpha=0.1\) level of significance. (b) Determine the critical values for...
Study smarter with the SolutionInn App