You are welcome to use Excel to do your calculations and copy and paste your answers...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are welcome to use Excel to do your calculations and copy and paste your answers here. 1. [6 points] You have been given the following information for NAUFIN Company. They have asked you to do trend and comparative analyses and evaluate the financial strength of the company. Compute the ratios below for 2019 (show your work), Ratio Actual 2017 Actual 2018 Actual 2019 1.55 0.92 9.21 0.2 7.3 0.062 $2.20 Current Quick Inventory Turnover Debt Ratio Times Interest Earned Net Profit Margin EPS 2019 information: Sales Cost of Goods Sold Operating Profit (EBIT) Interest Expense Net Income Preferred Dividends Earnings Avail for Common Shareholders 1.4 1 9.52 0.2 8.2 0.062 $1.75 $10,000,000 Accounts Receivable $7,500,000 Inventory $1,300,000 Total Current Assets $200,000 Total Assets $660,000 Total Current Liabilities $ 50,000 Total Liabilities 1.67 $0.88 7.89 0.35 6.50 0.07 $3.05 Common Stock $610,000 (200,000 shares outstanding) Industry Avg 1.85 1.05 8.6 0.3 8 0.053 $1.50 $800,000 $950,000 $2,000,000 $12,000,000 $1,200,000 $4,200,000 $600,000 2. [2 points] Your company has $5,000 in net fixed assets and is currently operating at 95% capacity. Your sales are $10,000 and you expect them to grow by 10% next year. What is the maximum sales level your net fixed assets can support? Sales at 95% = $10,000 Sale at 100% = $10,526.32 Calculation: (10000/95%) NAUFIN Pro Forma Income Statement For the Year Ended December 31, 2020 (in Sales Revenue Less: Cost of Goods Sold Gross Profit Less: Operating Expenses Operating Profit (EBIT) Less: Interest Expense Net profits before taxes Less: Taxes (rate = 25%) Net Income Less: Cash Dividends To Retained Earnings thousands) 2020 Assumptions/Calculations Forecast $6,200 Given $3,410 55% of sales revenue (6200*2750/5000) $2,790 6200-3410 $1,054 17% of sales revenue (6200*850/5000) $1,736 2790-1054 $200 20% of 1000 LT debt (1000*20%/100) $1,536 1736-200 $384 Given $1,152 1536-384 $461 Given (40% of Net Income) $691 1152-461 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equip NAUFIN Balance Sheet As of December 31, 2019 (in thousands) Liabilities & Owner's Equity Current Liabilities: $300 Accounts Payable 600 Notes Payable Total Current 800 Liabilities 1,700 Long-term Debt Total Liabilities 2,000 Owner's Equity: Common stock, at par Additional Paid-in Capital, common Retained Earnings Total Owner's Equity Total Liabilities & Total Assets $3,700 Owner's Equity Additional (external) funds needed, or excess funds $500 200 $0.00 700 900 1,600 700 500 900 2,100 $3,700 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equipment Total Assets Liabilities & Owner's Equity Current Liabilities: Accounts Payable Notes Payable Total Current Liabilities NAUFIN Pro Forma Balance Sheet As of December 31, 2020 (in thousands) Long-term Liabilities Total Liabilities Owner's Equity: Common Stock, par value Additional Paid-in Capital 2020 Forecast Assumptions/Calculations 372 6% of sales revenue (6200*6/100) 744 992 2,108 2,000 4,108 620 200 820 1,000 1,820 700 500 Retained Earnings Total Owner's Equity 1,116 2,316 Total Liabilities & Owner's Equity 4,136 Additional (external) funds needed, or excess funds (circle one) $28 Calculate the AFN above using the balance sheet, not the long AFN formula. Calculations: AutoSave OFF Home Insert Draw Design Layout A^ A BIU al x, x A Paste LG S Calibri 11 References Aav Po A A Double-click or double-tap to Edit Microsoft Excel Worksheet V Mailings E- Review View E E FCF = | FIN 311_Team Exam Review 1 Tell me A AaBbCcDdEe Normal AaBbCcDdEe No Spacing 4. [3 points] Use the 2019 financial statements and the 2020 projected sales from problem #3 to answer the following questions. a. Calculate the AFN (or excess funds) using the long AFN formula b. Why is this AFN different than the AFN calculated using the pro forma balance sheet? Consider the assumptions made in the formula that may not be true for this company. c. Which AFN is most accurate for NAUFIN company, the balance sheet AFN from problem 3 or the formula result from 4.a.? Why? 2019 EBIT = Tax rate (Effective) = 2019 Depreciation & Amortization = 2019 Investment in Gross Fixed Assets = 2019 NOWC = 2018 NOWC= AaBbCcDc AaBbCcDdEe AaBb( AaBbcDdEe Heading 1 Heading 2 Title Subtitle 5. [4 points] Find the following information from American Airlines' financial statements and use it to calculate their Free Cash Flows for 2019. Use finance.yahoo.com or money.msn.com to access their financial statements. Their ticker symbol is AAL. Investment in Gross fixed assets=2019 Gross PP&E - 2018 Gross PP&E Depreciation EBITDA - EBIT NOWC = (Cash + Accounts Receivable + Inventory) - (Accounts Payable + Accrued Liabilities) Focus AaBb CcDdEe Subtle Emph... REE Share Styles Pane Comments Dictate + 120% You are welcome to use Excel to do your calculations and copy and paste your answers here. 1. [6 points] You have been given the following information for NAUFIN Company. They have asked you to do trend and comparative analyses and evaluate the financial strength of the company. Compute the ratios below for 2019 (show your work), Ratio Actual 2017 Actual 2018 Actual 2019 1.55 0.92 9.21 0.2 7.3 0.062 $2.20 Current Quick Inventory Turnover Debt Ratio Times Interest Earned Net Profit Margin EPS 2019 information: Sales Cost of Goods Sold Operating Profit (EBIT) Interest Expense Net Income Preferred Dividends Earnings Avail for Common Shareholders 1.4 1 9.52 0.2 8.2 0.062 $1.75 $10,000,000 Accounts Receivable $7,500,000 Inventory $1,300,000 Total Current Assets $200,000 Total Assets $660,000 Total Current Liabilities $ 50,000 Total Liabilities 1.67 $0.88 7.89 0.35 6.50 0.07 $3.05 Common Stock $610,000 (200,000 shares outstanding) Industry Avg 1.85 1.05 8.6 0.3 8 0.053 $1.50 $800,000 $950,000 $2,000,000 $12,000,000 $1,200,000 $4,200,000 $600,000 2. [2 points] Your company has $5,000 in net fixed assets and is currently operating at 95% capacity. Your sales are $10,000 and you expect them to grow by 10% next year. What is the maximum sales level your net fixed assets can support? Sales at 95% = $10,000 Sale at 100% = $10,526.32 Calculation: (10000/95%) NAUFIN Pro Forma Income Statement For the Year Ended December 31, 2020 (in Sales Revenue Less: Cost of Goods Sold Gross Profit Less: Operating Expenses Operating Profit (EBIT) Less: Interest Expense Net profits before taxes Less: Taxes (rate = 25%) Net Income Less: Cash Dividends To Retained Earnings thousands) 2020 Assumptions/Calculations Forecast $6,200 Given $3,410 55% of sales revenue (6200*2750/5000) $2,790 6200-3410 $1,054 17% of sales revenue (6200*850/5000) $1,736 2790-1054 $200 20% of 1000 LT debt (1000*20%/100) $1,536 1736-200 $384 Given $1,152 1536-384 $461 Given (40% of Net Income) $691 1152-461 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equip NAUFIN Balance Sheet As of December 31, 2019 (in thousands) Liabilities & Owner's Equity Current Liabilities: $300 Accounts Payable 600 Notes Payable Total Current 800 Liabilities 1,700 Long-term Debt Total Liabilities 2,000 Owner's Equity: Common stock, at par Additional Paid-in Capital, common Retained Earnings Total Owner's Equity Total Liabilities & Total Assets $3,700 Owner's Equity Additional (external) funds needed, or excess funds $500 200 $0.00 700 900 1,600 700 500 900 2,100 $3,700 Assets Current Assets: Cash Accounts Receivable Inventory Total Current Assets Net Property, Plant & Equipment Total Assets Liabilities & Owner's Equity Current Liabilities: Accounts Payable Notes Payable Total Current Liabilities NAUFIN Pro Forma Balance Sheet As of December 31, 2020 (in thousands) Long-term Liabilities Total Liabilities Owner's Equity: Common Stock, par value Additional Paid-in Capital 2020 Forecast Assumptions/Calculations 372 6% of sales revenue (6200*6/100) 744 992 2,108 2,000 4,108 620 200 820 1,000 1,820 700 500 Retained Earnings Total Owner's Equity 1,116 2,316 Total Liabilities & Owner's Equity 4,136 Additional (external) funds needed, or excess funds (circle one) $28 Calculate the AFN above using the balance sheet, not the long AFN formula. Calculations: AutoSave OFF Home Insert Draw Design Layout A^ A BIU al x, x A Paste LG S Calibri 11 References Aav Po A A Double-click or double-tap to Edit Microsoft Excel Worksheet V Mailings E- Review View E E FCF = | FIN 311_Team Exam Review 1 Tell me A AaBbCcDdEe Normal AaBbCcDdEe No Spacing 4. [3 points] Use the 2019 financial statements and the 2020 projected sales from problem #3 to answer the following questions. a. Calculate the AFN (or excess funds) using the long AFN formula b. Why is this AFN different than the AFN calculated using the pro forma balance sheet? Consider the assumptions made in the formula that may not be true for this company. c. Which AFN is most accurate for NAUFIN company, the balance sheet AFN from problem 3 or the formula result from 4.a.? Why? 2019 EBIT = Tax rate (Effective) = 2019 Depreciation & Amortization = 2019 Investment in Gross Fixed Assets = 2019 NOWC = 2018 NOWC= AaBbCcDc AaBbCcDdEe AaBb( AaBbcDdEe Heading 1 Heading 2 Title Subtitle 5. [4 points] Find the following information from American Airlines' financial statements and use it to calculate their Free Cash Flows for 2019. Use finance.yahoo.com or money.msn.com to access their financial statements. Their ticker symbol is AAL. Investment in Gross fixed assets=2019 Gross PP&E - 2018 Gross PP&E Depreciation EBITDA - EBIT NOWC = (Cash + Accounts Receivable + Inventory) - (Accounts Payable + Accrued Liabilities) Focus AaBb CcDdEe Subtle Emph... REE Share Styles Pane Comments Dictate + 120%
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations for NAUFIN Company based on the information provided 1 Ratios for 2019 Cur... View the full answer
Related Book For
Fundamental Accounting Principles
ISBN: 978-0071051507
Volume I, 14th Canadian Edition
Authors: Larson Kermit, Tilly Jensen
Posted Date:
Students also viewed these finance questions
-
You are the legislative liaison for a state elected official. This official instructs you to provide them with a detailed word brief on the current and developing legislative and regulatory treatment...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
You have been given the following information for RPE Consulting for the year ended July 31, 2014. Required 1. Prepare the company's income statement, statement of changes in equity, and balance...
-
A lightweight, rigid beam 10.0 m long is supported by a cable attached to a spring of force constant k = 8.25 kN/m as shown in Figure P12.38. When no load is hung on the beam (Fg = 0), the length L...
-
A brother and sister try to communicate with a string tied between two tin cans (FIGURE 14-44). If the string is 7.6 m long, has a mass of 29 g, and is pulled taut with a tension of 18 N, how much...
-
What major objectives should be considered when conducting the BIA?
-
What is the link between perception and attribution?
-
Patterson Shirt Company sells on credit and manages its own receivables. Average experience for the past three years has been the following: The owner of Patterson is considering whether to accept...
-
Does the economy of the United States affect world markets? Yes. The United States is a major economic player in the world markets. O Yes. The United States controls most foreign world trade. No....
-
Refer to the first 100 minutes of the computer simulation of the current operation of Herr Cutter's barber shop presented in Figure 12.7 and summarized in Figure 12.8. Now consider the alternative of...
-
A ray of light in air is incident at an angle of 25.0 on a glass slide with index of refraction 1.27. (a) At what angle is the ray refracted? from the normal (b) If the wavelength of the light in...
-
a) it is given that P=13 lips and d=1/2 in diameter determine the max stress in the plate. It is not drilled.
-
Application 1. You are having a marketing meeting and are trying to come up with a new advertising campaign for Hank's Gardening Tools. You have decided that the most efficient way to come up with...
-
The speed drives the belt at 1 3 1 9 m / min . If the belt being used is rated at only 2 0 m / sec , is it okay for operation? Explain your answer.
-
Employed by a consumer products organization that has been rapidly growing for the past several years. The organization is primarily focused on prepackaged baby food and ready mix formula all made...
-
Two years have passed, and you recently received a call from your Chief Executive Officer asking for a meeting with you to discuss the status of the organization. During the meeting, the CEO...
-
3 2 points eBook Brief Exercise 11-14 (Algo) Change in estimate; useful life of equipment [LO11-5] At the beginning of 2022, Robotics Incorporated acquired a manufacturing facility for $12.8 million....
-
(a) As Section 17.3 discusses, high-frequency sound waves exhibit less diffraction than low-frequency sound waves do. However, even high-frequency sound waves exhibit much more diffraction under...
-
At the end of each year, Deutch Supply Co. uses the simplified balance sheet approach (i.e., percent of accounts receivable) to estimate bad debts. On December 31, 2014, it has outstanding accounts...
-
The following is information for Dundee Realty: a. Balance per the bank statement dated October 31, 2014, is $26,830. b. Balance of the Cash account on the company books as of October 31, 2014, is...
-
The bank reconciliation prepared by Village-on-the-l.ake Condos on May 31, 2014, is shown below: The Cash account in the General Ledger appeared as follows on June 30: A list of deposits made and...
-
Why do shareholders in an acquired company agree to the dilution of their shareholdings after completion of the merger?
-
Why are the legal procedures related to mergers so onerous?
-
Where does the creation of value lie in a merger?
Study smarter with the SolutionInn App