You have been hired to help Q&A Aviation to evaluate their current financial position and make...
Fantastic news! We've Found the answer you've been seeking!
Question:
![You have been hired to help Q&A Aviation to evaluate their current financial position and make](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/650da03a98fbd_1695391796486.jpg)
![Q&A Aviation Income Statement (000) Sales Cost of Goods Sold Gross Profit Expenses Depreciation EBIT Interest](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/650da07aceb75_1695391850894.jpg)
Transcribed Image Text:
You have been hired to help Q&A Aviation to evaluate their current financial position and make recommendations to help them move forward. They have been in business for 10 years, and manufacture and sell light airplanes, mostly to individuals who own and fly their own planes. These planes have been praised for safety and reliability by industry analysts, and sales have been steadily growing. Q&A sells two models: the Eagle for $78,000 and the Kingfisher for $55,000. The company generally builds planes to order using prefabricated parts, which means that they can complete an order in about five weeks. They require a deposit at the time of the order, and get another partial payment around week three. Their competitors can take up to a year and a half to complete a plane once it is ordered. The founders are considering making some planes without orders that they would keep on hand and sell at a premium to someone who wanted one even faster than five weeks. They have provided you with the following financial information: -627 -115 S -258 S 2141 U 1368 S Q&A Aviation Balance Sheet (000s) Assets 20X1 20X2 Cash Accounts Receivable Inventory Total Assets Current Plant, Property and Eq. Accumulated Dep'n Fixed Assets (Net) Total Assets 1067 823 1296 3186 21663 Liabilities and 20X1 Equity 440 Accounts Payable 708 Notes Payable 1038 Accruals 2186 Total Liabilities Current 23804 Long Term Debt (6314) (7682) 15349 16122 Common Stock Retained Earnings Total Equity 18535 18308 Total Liabilities and Equity 654 2300 267 3221 6477 350 8487 8837 18535 20X2 889 2030 275 3194 5044 350 9720 10070 18308 235 S -270 U 8 S 1433 U Q&A Aviation Income Statement (000) Sales Cost of Goods Sold Gross Profit Expenses Depreciation EBIT Interest EBT Tax (30%) Net Income Dividends Paid Additions to Retained Earnings Current Ratio Quick Ratio ACP Inventory Turnover Fixed Asset Turnover Total Asset Turnover Debt Ratio Times Interest Earned Gross Profit Margin Profit Margin Return on Assets Return on Equity 20X1 Industry 1.43 0.38 15 days 4.90 0.56 0.68 0.52 8.06 In addition to the company information, they have acquired industry comparison information as shown in the following table: 35.2% 4.0% 10.5% 16.5% 28934 19978 8956 Q&A 20X1 3612 1145 4199 523 3676 1103 2573 520 2053 2012 30499 22225 Q&A 20X2 8274 3867 1368 3039 478 2561 768 1793 560 1233 Instructions: 1. Complete the chart above comparing the company to the industry. 2. Write your analysis of the changes that have been made in the company over the past two years. 3. Write your analysis of the company as it compares to the industry ratios. 4. What areas to you recommend the company to concentrate on to improve their financial health? 5. Complete the cash flow statement for 20X2 You have been hired to help Q&A Aviation to evaluate their current financial position and make recommendations to help them move forward. They have been in business for 10 years, and manufacture and sell light airplanes, mostly to individuals who own and fly their own planes. These planes have been praised for safety and reliability by industry analysts, and sales have been steadily growing. Q&A sells two models: the Eagle for $78,000 and the Kingfisher for $55,000. The company generally builds planes to order using prefabricated parts, which means that they can complete an order in about five weeks. They require a deposit at the time of the order, and get another partial payment around week three. Their competitors can take up to a year and a half to complete a plane once it is ordered. The founders are considering making some planes without orders that they would keep on hand and sell at a premium to someone who wanted one even faster than five weeks. They have provided you with the following financial information: -627 -115 S -258 S 2141 U 1368 S Q&A Aviation Balance Sheet (000s) Assets 20X1 20X2 Cash Accounts Receivable Inventory Total Assets Current Plant, Property and Eq. Accumulated Dep'n Fixed Assets (Net) Total Assets 1067 823 1296 3186 21663 Liabilities and 20X1 Equity 440 Accounts Payable 708 Notes Payable 1038 Accruals 2186 Total Liabilities Current 23804 Long Term Debt (6314) (7682) 15349 16122 Common Stock Retained Earnings Total Equity 18535 18308 Total Liabilities and Equity 654 2300 267 3221 6477 350 8487 8837 18535 20X2 889 2030 275 3194 5044 350 9720 10070 18308 235 S -270 U 8 S 1433 U Q&A Aviation Income Statement (000) Sales Cost of Goods Sold Gross Profit Expenses Depreciation EBIT Interest EBT Tax (30%) Net Income Dividends Paid Additions to Retained Earnings Current Ratio Quick Ratio ACP Inventory Turnover Fixed Asset Turnover Total Asset Turnover Debt Ratio Times Interest Earned Gross Profit Margin Profit Margin Return on Assets Return on Equity 20X1 Industry 1.43 0.38 15 days 4.90 0.56 0.68 0.52 8.06 In addition to the company information, they have acquired industry comparison information as shown in the following table: 35.2% 4.0% 10.5% 16.5% 28934 19978 8956 Q&A 20X1 3612 1145 4199 523 3676 1103 2573 520 2053 2012 30499 22225 Q&A 20X2 8274 3867 1368 3039 478 2561 768 1793 560 1233 Instructions: 1. Complete the chart above comparing the company to the industry. 2. Write your analysis of the changes that have been made in the company over the past two years. 3. Write your analysis of the company as it compares to the industry ratios. 4. What areas to you recommend the company to concentrate on to improve their financial health? 5. Complete the cash flow statement for 20X2
Expert Answer:
Answer rating: 100% (QA)
To complete the chart comparing the company to the industry calculate the ratios for QA Aviation based on the provided financial information 1 Current Ratio Current Ratio Total Current Assets Total Cu... View the full answer
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these accounting questions
-
(Constraint Optimization) Given the production function: Q = 2 K 1/2 L1/2 Where, Q is the total output. K refers capital and L refers Labour. 1 unit of capital costs $4 and 1 unit of labour costs $3....
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Explain impact of IT on cross border communication and how to manage cross cultural business communication successfully.
-
What is the relationship between the audit of fixed assets accounts and the audit of repair and maintenance accounts? Explain how the auditor organizes the audit to take this relationship into...
-
Determine the value of the literal numbers in each of the given matrix equalities. If the matrices cannot be equal, explain why. C + D D - 2E 3 2 6
-
Foi the fiscal year ending December 31, how will consolidated net income of this business combination be determined if Hill acquires all of Lorings stock? a. Hills income for the past year plus...
-
When Ridge Intellectual, a graphics design firm, implemented 360-degree feedback in its organization two years ago, it was met with resistance and was eventually discontinued. Ron Bartlett, the...
-
Set up a Balance Sheet from the information below to determine Net Worth: Cash in the bank 5 , 0 0 0 ; total credit card balance 1 0 ; gross wages 7 2 , 0 0 0 ; retirement account 1 5 0 , 0 0 0 ; car...
-
The shaft is supported by a smooth thrust bearing at B and a journal bearing at C. Determine the resultant internal loadings acting on the cross section at E. - 4 ft 4 ft +4 ft- 4 ft- 400 lb 800 lb
-
It asks to find the heat transfer rate of the dehumidification section in KW Moist air enters an air-conditioning system as shown in the figure below at T = 28C, 1 = 70% and a volumetric flow rate of...
-
Hogan Business Systems has a small number of sales on account but is mostly a cash business. Consequently, it uses the direct write-off method to account for uncollectible accounts. During 2011 Hogan...
-
Bourret Inc. experienced the following events for the first two years of its operations. 2011: 1. Provided \(\$ 60,000\) of services on account. 2. Provided \(\$ 25,000\) of services and received...
-
A flowrate of lubricant oil is \(5 \mathrm{~kg} / \mathrm{s}\) passing through a Venturi tube. The ratio of areas of the Venturi tube is \(0.005 \mathrm{~m}^{2} /0.002 \mathrm{~m}^{2}\). The density...
-
Sketch on separate axes, in the interval 0 360, the graphs of: In each case show the coordinates of any maximum and minimum points, and of any points at which the curve meets the axes. a y = sec...
-
The wheel of radius \(r=300 \mathrm{~mm}\) rolls to the right without slipping and has a velocity \(v_{O}=3 \mathrm{~m} / \mathrm{s}\) of its center \(O\). Calculate the velocity of point \(A\) on...
-
E19-15 (similar to) * Question Help Prescott makes handheld calculators in two models: basic and professional. Prescott estimated $624,000 of manufacturing overhead and 520,000 machine hours for the...
-
Evaluate the function at the given value(s) of the independent variable. Simplify the results. (x) = cos 2x (a) (0) (b) (- /4) (c) (/3) (d) ()
-
When performing ADA as a substantive test, the auditor: a. Uses ADA to match electronic information that otherwise would have been audited manually. b. Uses ADA to identify high-risk transactions and...
-
Identify the factors that influence sample size in a test of controls. Provide an example related to each factor in terms of how it would potentially increase the level of control testing.
-
Omega Airways is a public company and a new client of your audit firm. Its accounting policy for revenue is to credit unearned revenue when cash is received, and subsequently transfer to revenue in...
-
E19.6. Credit Scoring for a Firm with a Ratings Downgrade: Maytag Corporation (Medium) Maytag Corporation is the established manufacturer of washing machines, dryers, dish- washers, and other home...
-
E19.4. Z-Scoring (Easy) Below are ratios for some of the firms that have appeared in this book, for their 1998 fiscal year. Working Retained Capital Earnings Earnings before Interest and Taxes Market...
-
Fruit of the Loom Ltd. fared poorly from 1997 to 1999. Between April 1997 and October. 1999, its stock price dropped from $38 to $3, a 92 percent loss in market value. Fruit of the Loom manufactures...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App