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...
-
Your friend says that the buoyant force of the atmosphere on an elephant is significantly greater than the buoyant force of the atmosphere on a small helium-filled balloon. What do you say?
-
Let a represent the arithmetic mean of k numbers whose sum is S. Which of the following is equal to 1? A. B. C. a.k S E. S.a k S.k a D. S.a.k k a. S
-
In a nutritional products plant, a plate heat exchanger cools infant formula by approximately \(25{ }^{\circ} \mathrm{C}\) from an inlet temperature of \(68{ }^{\circ} \mathrm{C}\) as it flows...
-
Record the following transactions using T accounts, assuming the periodic inventory system is used: Aug. 4 Sold merchandise on credit to Rock Company, terms n/30, FOB destination, $2,520. 5 Paid...
-
Need help expanding the questions below. State of Ohio's position on the ban? What legislation if any supports or opposes the ban and or tries to protect smokers in the workplace? How smoking in...
-
Calculator Calculating Payroll Taxes Expense and Preparing Journal Entry Selected information from the payroll register of Ebeling's Dairy for the week ended July 7, 20--, is shown below. The SUTA...
-
Psycho Mycko specialises in online psychometric profiling. The company was incorporated in 2018 and has grown rapidly over the past 3 years to a total of 310 staff today. Its headquarters are located...
-
If Peter has no black professional touring bikes in inventory in Germany North and he wishes to have a safety stock of 2, how many must he schedule for production next month for this sales...
-
Give 5 things or instances that showcase how your school impacts you and made you a better person, a better student, a better member of the community and possibly, a good leader in the future then...
-
After studying the 20th and 21st century Multimedia Forms, answer the following question. 1. How do you think should an artist be able to effectively convey emotions or ideas? 2. If you were given an...
-
Promoting a Positive Learning Environment Refer to scenes in the video clips where the teacher candidate provided a positive learning environment. How did she demonstrate mutual respect for. rapport...
-
What dietary fats provided by breastmilk or infant formula particularly important for children less than 2 years?
-
Yourbondportfolioatyear-endlooksasfollows: $ (millions) Bonds Maturity(years) Duration(years) YieldtoMaturity (percent) 4 U.S.Treasuries 5.5 5 4.00 6 CorpBonds 25 20 5.50 Whatistheweightedaverage...
-
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...
-
Consider each table below. Is the data presented consistent with the Phillips curve model of wage determination? Each table has a point \(A\) and a point B. Startyour answer with true/false/...
-
In a 2012 book, The New Geography of Jobs (a book described by Barack Obama as 'a timely and smart discussion of how different cities and regions have made a changing economy work for them', and by...
-
Nature, a leading science magazine, argues (https://www.nature.com/articles/d41586-020-01518-y) that COVID19 will force universities to confront long-standing challenges in higher education, such as...
Study smarter with the SolutionInn App