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 a. Cash collection Accounts receivable Inventory $20,000 280,000 126.000 ii. i. December credit sales % cash sales each month PPE, net 426,000 4,000,000 iii. % credit sales collected in same month $4,426,000 iv. %credit sales collected in next month b. Liabilities C. January total sales Inventory information $400,000 0% 30% 70% $300,000 Current Operating loan $200,000 i. February total sales $250,000 Accounts payable Non-current borrowings 190,400 390,400 3.000.000 iii. ii. Gross profit ratio all months 30% % 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 20% Income taxes are paid at the end of the fiscal year. 1. 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 m. Maximum operating loan balance at end of January . Any excess cash will be used to pay down the operating loan. Q. Any cash not able to be provided by the operating loan will be raised by issuing common shares. Required: 1. Using a format the budget worksheet below (must), record the above information. $5,000 $0 $10,000 $20,000 $200,000 ASSETS LIABILITIES + S/H EQUITY Tran Cash + S. Acc. Rec. Invent + + PPE Op. Loan Acc. + Pay. L/T Debt Com mon + + Share Ret. Earn. Desc.. S Cf. 20,0 00 280,0 00 126,0 00 4,000,0 00 200,0 00 190,4 00 3,000,0 00 70,00 965,6 00 Total S 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 a. Cash collection Accounts receivable Inventory $20,000 280,000 126.000 ii. i. December credit sales % cash sales each month PPE, net 426,000 4,000,000 iii. % credit sales collected in same month $4,426,000 iv. %credit sales collected in next month b. Liabilities C. January total sales Inventory information $400,000 0% 30% 70% $300,000 Current Operating loan $200,000 i. February total sales $250,000 Accounts payable Non-current borrowings 190,400 390,400 3.000.000 iii. ii. Gross profit ratio all months 30% % 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 20% Income taxes are paid at the end of the fiscal year. 1. 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 m. Maximum operating loan balance at end of January . Any excess cash will be used to pay down the operating loan. Q. Any cash not able to be provided by the operating loan will be raised by issuing common shares. Required: 1. Using a format the budget worksheet below (must), record the above information. $5,000 $0 $10,000 $20,000 $200,000 ASSETS LIABILITIES + S/H EQUITY Tran Cash + S. Acc. Rec. Invent + + PPE Op. Loan Acc. + Pay. L/T Debt Com mon + + Share Ret. Earn. Desc.. S Cf. 20,0 00 280,0 00 126,0 00 4,000,0 00 200,0 00 190,4 00 3,000,0 00 70,00 965,6 00 Total S 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 ...
-
Burger Doodle is a fast-food restaurant that processes an average of 680 food orders each day. The average cost of each order is $6.15. Four percent of the orders are incorrect, and only 10% of the...
-
The photo response of the retina of the human eye at low light levels depends on individual photosensitive molecules in rod cells being excited by the incident light. When excited, these molecules...
-
The concentration of an antihistamine in the bloodstream of a healthy adult is modeled by where C is measured in grams per liter and t is the time in hours since the medication was taken. What is the...
-
In February 2007, The Elliot Group, Inc., an Illinois real estate developer, made a deal with the Village of Arlington Heights to develop property in that village. Arlington Market, LLC, was...
-
For the year ended December 31, 2014, the job cost sheets of Cinta Company contained the following data. Other data: 1. Raw materials inventory totaled $15,000 on January 1. During the year, $140,000...
-
How did you apply active listening to seek information and confirm your understating as you interacted with a child or group of children?
-
Attend a Killeen City Council Meeting, or tune in to local Channel 10 in the Killeen area to view the meeting there. You could go to a county courthouse to watch a celebrity's trial, or you could...
-
Suppose h is a nonnegative integer and we are given that: h [3i i=0 Find an integer lower bound for h which does not include a sum.
-
Assume Zero Initial conditions. Plot the response. Use Laplace transform to calculate the response of the system 3x(t) + 6x(t) + 12x(t): 38(t) - 8(t-1)
-
Given: f(x)= x) = { 2, if[x] is even is odd C. and g(x)=f() *Probably you will want to start by investigating both functions at a bunch [10 or 20 or 30] of various x-values! a. Sketch g(x) on the x...
-
29. Why does the U.S. government allow millions of tons of food to rot or be destroyed every year instead of feeding it to the poor?
-
What's your thoughts on that? Economic growth misses expectations as GDP increases 0.6 per cent in September quarter By business reporters Michael Janda and Rhiana Whitson, Wed 7 Dec 2022 Australia's...
-
Write a paper on Harwood Medical Instrument PLC also define its Balanced Scorecard Plan
-
Study the pictures/images below. Obviously these was focus on LT sociology, anthropology and poltical science. Try to do some analysis by finding clues that are synonymous with the main concepts....
-
Using two CST elements, solve the simple shear problem depicted in the figure and determine whether the CST elements can represent the simple shear condition accurately or not. Material properties...
-
A heat conduction problem is modeled using four onedimensional heat conduction elements, as shown in figure 4.6. All elements are of the same length, \(L=1 \mathrm{~m}\), cross sectional area of...
-
Consider heat conduction in a uniaxial rod surrounded by a fluid. The left end of the rod is at \(T_{0}\). The free stream temperature is \(T^{\infty}\). There is convective heat transfer across the...
Study smarter with the SolutionInn App