Quickfix Autoparts Consolidated Balance Sheet ASSETS 2019 2020 Current Assets Cash & marketable security 2$ 309,099...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Quickfix Autoparts Consolidated Balance Sheet ASSETS 2019 2020 Current Assets Cash & marketable security 2$ 309,099 Accounts receivable 12,000 270,000 591,099 Inventory Total current assets Property and equipment (net) TOTAL ASSETS (A) 200,000 791,099 LIABILITIES Current liabilities Accounts payable 10,506 5,100 145,000 Accrued liabilities Short-term bank loan Total Current Liabilities (CL) 160,606 Long term debt 271,000 Total Liabilities 431,606 Stockholders' equity Common stock (100,000 shares authorized and outstanding) 320,000 Retained earnings 39,493 Total liabilities and shareholders' equity 791,099 1. Roberto, owner of Quickfix Autoparts (QA), forecast that 2020 sales will increase to $786,000. The gross profit margin was estimated at 16%. The total operating expenses had been estimated in $72,606. The interest expense was estimated equal to 6% of the estimated sales. Additionally, assume (1) that the company's total assets are being used at nearly full capacity, so the assets will have to increase as sales grow, (2) the accounts payable and accruals will also grow in proportion to sales. Determine the amount of additional financing needed (AFN) and pro forma financial statements (balance sheet and Income Statement). (25 pts). 2. Complete the table with financial ratios (10 pts). Comment on Quickfix's general financial condition. What arguments would have to be made to convince the bank that they should grant Quickfix the loan? (The comments and arguments must be complete and specific). (10 pts) (Total 20 pts) Selected ratios 2019 2020 Net profit margin Debt ratio Debt to equity Time interest earned Current ratio concentrating in Finance. When Alberto started his internship, Roberto explained exactly what his concerns were. "I'm going to have the raise funds for future growth, and given my recent financial situation, the prospects look pretty bleak. The bank's commercial loan committee is going to want some pretty convincing arguments as to why they should grant me the loan. I need to put some concrete remedial measures in place, and was hoping that you can help sort things out, Alberto", said Roberto. Quickfix Autoparts Income Statement 2019 2020 $ 655,000.00 Net sales $ 537,100.00 Cost of goods sold 2. 117,900.00 Gross Profit 15,345.00 Administrative and Selling Expenses 25,000.00 Depreciation 2$ 3,557.00 Miscellaneous expenses 43,902.00 Total operating expenses 73,998.00 EBIT 2$ 35,900.00 Interest Expense 2$ 38,098.00 Before tax earnings 2$ 15,239.20 Tax (40%) 22,858.80 Net Income 3. Assume that Quickfix's bank has been pressuring the firm to improve its liquidity. Which of the following actions proposed by Alberto Alvarez (Quickfix's external adviser) do you believe will actually achieve this objective? Why or Why not? (12 pts; 3 pts each one). (You must assess every option (a -d) and the answer offered must include: Yes or No and why). a. Sell new equity and use the proceeds to purchase an equipment. b. Use cash and marketable securities to pay off short-term bank borrowing and accounts payable. c. Borrow long-term and use the proceeds to pay off short-term debt. d. Sell surplus fixed assets and invest the proceeds in marketable securities. Quickfix Autoparts Consolidated Balance Sheet ASSETS 2019 2020 Current Assets Cash & marketable security 2$ 309,099 Accounts receivable 12,000 270,000 591,099 Inventory Total current assets Property and equipment (net) TOTAL ASSETS (A) 200,000 791,099 LIABILITIES Current liabilities Accounts payable 10,506 5,100 145,000 Accrued liabilities Short-term bank loan Total Current Liabilities (CL) 160,606 Long term debt 271,000 Total Liabilities 431,606 Stockholders' equity Common stock (100,000 shares authorized and outstanding) 320,000 Retained earnings 39,493 Total liabilities and shareholders' equity 791,099 1. Roberto, owner of Quickfix Autoparts (QA), forecast that 2020 sales will increase to $786,000. The gross profit margin was estimated at 16%. The total operating expenses had been estimated in $72,606. The interest expense was estimated equal to 6% of the estimated sales. Additionally, assume (1) that the company's total assets are being used at nearly full capacity, so the assets will have to increase as sales grow, (2) the accounts payable and accruals will also grow in proportion to sales. Determine the amount of additional financing needed (AFN) and pro forma financial statements (balance sheet and Income Statement). (25 pts). 2. Complete the table with financial ratios (10 pts). Comment on Quickfix's general financial condition. What arguments would have to be made to convince the bank that they should grant Quickfix the loan? (The comments and arguments must be complete and specific). (10 pts) (Total 20 pts) Selected ratios 2019 2020 Net profit margin Debt ratio Debt to equity Time interest earned Current ratio concentrating in Finance. When Alberto started his internship, Roberto explained exactly what his concerns were. "I'm going to have the raise funds for future growth, and given my recent financial situation, the prospects look pretty bleak. The bank's commercial loan committee is going to want some pretty convincing arguments as to why they should grant me the loan. I need to put some concrete remedial measures in place, and was hoping that you can help sort things out, Alberto", said Roberto. Quickfix Autoparts Income Statement 2019 2020 $ 655,000.00 Net sales $ 537,100.00 Cost of goods sold 2. 117,900.00 Gross Profit 15,345.00 Administrative and Selling Expenses 25,000.00 Depreciation 2$ 3,557.00 Miscellaneous expenses 43,902.00 Total operating expenses 73,998.00 EBIT 2$ 35,900.00 Interest Expense 2$ 38,098.00 Before tax earnings 2$ 15,239.20 Tax (40%) 22,858.80 Net Income 3. Assume that Quickfix's bank has been pressuring the firm to improve its liquidity. Which of the following actions proposed by Alberto Alvarez (Quickfix's external adviser) do you believe will actually achieve this objective? Why or Why not? (12 pts; 3 pts each one). (You must assess every option (a -d) and the answer offered must include: Yes or No and why). a. Sell new equity and use the proceeds to purchase an equipment. b. Use cash and marketable securities to pay off short-term bank borrowing and accounts payable. c. Borrow long-term and use the proceeds to pay off short-term debt. d. Sell surplus fixed assets and invest the proceeds in marketable securities.
Expert Answer:
Related Book For
Principles of Accounting
ISBN: 978-1133626985
12th edition
Authors: Belverd E. Needles, Marian Powers and Susan V. Crosson
Posted Date:
Students also viewed these general management questions
-
Find the operating ratio and the gross profit margin ratio for Molene Interent Store if the month's income statement shows net sales, $285,832; cost of goods sold, $198,530; gross profit, $87,302;...
-
Find the operating ratio and the gross profit margin ratio for Molene Internet Store if the month's income statement shows net sales, $285,832; cost of goods sold, $198,530; gross profit, $87,302;...
-
Find the gross profit margin ratio for Mile Wide for 2012 and 2013.
-
Show how each transformation may be accomplished by using a nitrile as an intermediate. You may use any necessary reagents. (a) Hexan-1-ol heptan-1-amine (b) Cyclohexanecarboxamide cyclohexyl ethyl...
-
D-Mannitol, which occurs naturally in olives, onions, and mushrooms, can be made by NaBH4 reduction of d-mannose. Draw its structure.
-
Ray Steen recently started a business. During the first few days of operation, Mr. Steen transferred $100,000 from his personal account into a business account for a company he named Steen...
-
In a new highly automated factory, labor costs are expected to decrease at an annual rate of 5 percent; material costs will increase at an annual rate of 4 percent; overhead costs will increase at 8...
-
Following is a bank reconciliation for Pizza Express for May 31, 2013: Because of limited funds, Pizza Express employed only one accountant who was responsible for receiving cash, recording receipts...
-
(b) Compute interest and find the maturity date for the following notes. Hint: Omit the date the note is issued but include the due date. Date of Note Principal Interest Rate (%) Terms (a) June 10...
-
A clinics cost and visit data are as follows. Calculate its average and marginal costs. Note that you can only calculate marginal cost as visits increase from 100 to 110. Visits 100 110 Total Cost...
-
Bikes.com is a web-based company that sells bicycles on the internet. Its distinctive feature is that it allows customers to customize the design when they order and then to receive quick delivery....
-
Globe Industries' year-end is May 31. Based on an analysis of the unadjusted trial balance at May 31, 2023, the following information was available: a. Accrued revenue at year-end totaled $24,300 b....
-
A component arrives gradually and at the rate of 20 units per week and is used with the rate of 5 units per week. The item costs $2,000 per unit. The cost per order is $10,000 and the annual holding...
-
K Simplify the expression. (6x3y) (7xy-3) (6x3y2) (7xy-3)=(Simplify your answer. Use positive exponents only.)
-
If the auditor's risk assessment procedures suggest that internal control in the inventor and production cycle is weak, he/she will: a. increase his test of controls. b. increase his substantive...
-
a) You have been asked to value two bonds a corporate bond and a government bond. Both bonds are issued in the same currency and country and have the following details: Government Face Value 1,000...
-
A long rod with a circular cross section is made of aluminum (E = 71.7 GPa). The length of the rod is 2,000 mm, and the diameter of the rod is 6 mm. The rod is subjected to an axial load of 19 kN....
-
1. Which of the four major types of information systems do you think is the most valuable to an organization? 2. How do you critically associate the ideas of business agility and business efficiency...
-
A list of control procedures follows. a. Authorization b. Recording transactions c. Documents and records d. Physical controls e. Periodic independent verification f. Separation of duties g. Sound...
-
The accounts and balances that follow are from Kellman Companys general ledger. Compute the (1) Working capital (2) Current ratio. (Round to one decimal place.) Accounts Payable ............ $13,280...
-
All Eyes Security Services Company provides security monitoring services. It employs four security specialists. Each specialist works an average of 180 hours a month. The companys controller has...
-
The number of claims received by an insurance company during a week follows a Poisson ( ) distribution. The weekly number of claims observed over a ten week period are: \(5,8,4,6,11,6,6,5,6,4\). (a)...
-
The number of particles emitted by a radioactive source during a ten second interval has the Poisson( ) distribution. The radioactive source is observed over ve non-overlapping intervals of ten...
-
The number of defects per 10 meters of cloth produced by a weaving machine has the Poisson distribution with mean . You examine 100 meters of cloth produced by the machine and observe 71 defects. (a)...
Study smarter with the SolutionInn App