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:
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.
-
A silicon diode, whose current-voltage characteristics are given in Fig. 960- resistor. What battery voltage is needed to produce a 12-mA current?
-
how the job characteristics interact with each other in this model. If someone's job is completely lacking in autonomy (or feedback), regardless of levels of variety, identity, and significance, the...
-
What recruiting objectives are being met through the use of online recruitment?
-
At the beginning of its operations in March 2016, Mastiff Supplies Ltd. began with 7,500 units of inventory that it purchased at a cost of $7.00 each. The companys purchases during March were as...
-
6 a. Show by induction on n that 12 +22 +32 +...+n = n(n+1)(2n+1) b. Let T(n) be defined recursively as follows: T(1) = c, and T(n) = 5T (#)+c vn5 C. where c is an arbitrary constant, and n = 5k for...
-
What is the subject matter of each of the following TAM? a. TAM 200703019 b. TAM 201734007 c. TAM 9853001
-
Expand the (x, y) = (2 x)y-4cos (x- 2y) + 47 ; | x |
-
A CachedRowSet class is a that caches its data in a. Connected RowSet, database b. Disconnected RowSet, database c. Connected RowSet, memory d. Disconnected RowSet, memory
-
Generally, the JDBC API perform the following three functions a. Connect to database, load JDBC driver, perform the query b. Perform the query, connect to database, load JDBC driver c. Get result...
-
Provide a detailed description of the JDBC API, which includes: a. The definition of the JDBC and JDBC API b. The components defined in the JDBC API, including all classes and interfaces c. The...
-
Client server databases have several advantages over file server databases. These include a. Minimizing chances of crashes b. Provision of features for recovery c. Enforcement of security d....
-
The method can be used to either pick up a query result or update a datum. a. executeUpdate() b. execute() c. executeQuery() d. None of them
-
Start by completing the cash flows from operating activities. Then complete the remaining sections of the statement of cash flows including the schedule of noncash investing and financing activities....
-
Determine the values of the given trigonometric functions directly on a calculator. The angles are approximate. tan 0.8035
-
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...
-
For the particular case of hard spheres, the pressure in the virial equation of state is determined by evaluating the pair correlation function at contact. Write the pair correlation function as...
-
Use a virial expansion approach to determine the first few nontrivial order contributions to the pair correlation function \(g(r)\) in \(d\) dimensions. Show that the pair correlation function is of...
-
Show that, in the case of a degenerate gas of fermions \(\left(T \ll T_{F} ight)\), the correlation function \(g(r)\), for \(r \gg \hbar / p_{F}\), reduces to the expression \[g(r)-1=-\frac{3(m k...
Study smarter with the SolutionInn App