Before AUSING LTD approaches the bank for a loan the company has asked their internal credit...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Before AUSING LTD approaches the bank for a loan the company has asked their internal credit department to see if the firm can generate any internal funds. Hints: Calculate the omitted values in the table below. For calculations use 365 days in a year. What conclusions can you draw from your analysis? Unfortunately, the pandemic COV-19 crisis occurred in 2020. How would you modify your analysis? What ratios do you believe will be mostly impacted by the crisis? Be specific and provide a rationale. What supplementary information would you seek to increase your confidence in your conclusion? Note: You are not expected to conduct horizontal and vertical analysis nor derive cash flow statements when answering this question. AUSING LTD RATIOS 2014 LIQUIDITY RATIOS CURRENT RATIO QUICK RATIO ACTIVITY RATIOS INVENTORY TURNOVER AVG COLLECTION PERIOD (Days) AVG PAYMENT PERIOD (Days) FIXED-ASSET TURNOVER TOTAL ASSET TURNOVER PROFITABILITY RATIOS RETURN ON TOTAL ASSET RETURN ON NET WORTH PROFIT MARGIN ON SALES LEVERAGE RATIO DEBT RATIO 3.51 1.75 8.00 29.20 N/A 14.93 3.75 0.15 0.20 0.04 0.25 2017 2018 2019 INDUSTRY 2.00 2.50 1.04 1.16 6.18 39.82 N/A 10.58 12.56 2.81 2.89 ? ? ? 0.08 0.03 0.14 0.04 0.03 0.01 0.39 0.33 1.90 0.81 ? ? ? 10.84 2.27 0.10 0.18 0.05 0.43 2.00 1.50 4.25 29.0 30.0 13.30 3.00 0.10 0.15 0.03 0.30 AUSING LTD INCOME STATEMENT AND BALANCE SHEET 2014 INCOME STATEMENT NET SALES COGS GROSS PROFIT ADMIN, SELLING & INTEREST DEPRECIATION MISCELLANEOUS NET INCOME BEFORE TAX TAXES @ 40% NET INCOME BALANCE SHEET CASH ACCOUNTS RECEIVABLE INVENTORY TOTAL CURRENT ASSETS LAND & BUILDING MACHINERY OTHER FIXED ASSETS TOTAL ASSETS BANK NOTES PAYABLE ACCOUNTS PAYABLE ACCRUALS TOTAL CURRENT LIABILITIES MORTGAGE COMMON STOCK RETAINED EARNINGS TOTAL LIABILITY & EQUITY $5,000,000 $4,000,200 $ 999,800 $ 521,467 $ 80,000 EA GA 2018 2019 2017 $4,400,000| $ 5,600,000| $ 4,500,000 $3,400,000 $ 4,500,000 | $ 3,500,000 $1,000,000 $1,100,000 $1,000,000 $ 849,667 $ 519,000 $ 72,000 $ 582,000 $ 105,000 $ 80,000 77,000 $ 71,500 93,333 $ 337,500 $ 135,000 $ 202,500 $ 65,000 $ 93,000 $333,333 $ 220,000 $ $ 133,333 $ 88,000 $ 37,333 $ 200,000 $ 132,000 $ 56,000 EA EA EA $ $ 285,000 $ 575,000 50,000 $ 40,000 $ 900,000 $ 900,000 $ 100,000 $ 51,000 $1,335,000 $1,566,000 $ EA GA 2014 2017 $ 2018 2019 90,000 $ 70,000 $ 600,000 100,000 $ 120,000 $ 400,000 $ 480,000 $ $ 550,000 $ $ 500,000 $ 1,000,000 $ 1,490,000 $ 600,000 $ 800,000 $ 900,000 $ 1,150,000 $ 1,570,000 $ 100,000 $ 90,000 $ 217,000 $ 221,000 150,000 $ 260,000 $ 202,000 $ 179,000 $ 85,000 $ 66,000 $ 27,000 $ 15,000 $ 1,335,000 $ 1,566,000 | $ 1,936,000| $ 1,985,000 $ 47,000 $ 53,000 $ 110,000 $ 473,000 $ 156,000 $ 171,500 $ 233,800 $319,000 $ 82,000 $ 350,500 $ 252,200 $ 34,300 $ 596,000 $ 826,300 $ 36,000 $ 33,000 $ 1,150,000 $ 867,000 $ 154,000 $ 258,700 $1,936,000 $1,985,000 Before AUSING LTD approaches the bank for a loan the company has asked their internal credit department to see if the firm can generate any internal funds. Hints: Calculate the omitted values in the table below. For calculations use 365 days in a year. What conclusions can you draw from your analysis? Unfortunately, the pandemic COV-19 crisis occurred in 2020. How would you modify your analysis? What ratios do you believe will be mostly impacted by the crisis? Be specific and provide a rationale. What supplementary information would you seek to increase your confidence in your conclusion? Note: You are not expected to conduct horizontal and vertical analysis nor derive cash flow statements when answering this question. AUSING LTD RATIOS 2014 LIQUIDITY RATIOS CURRENT RATIO QUICK RATIO ACTIVITY RATIOS INVENTORY TURNOVER AVG COLLECTION PERIOD (Days) AVG PAYMENT PERIOD (Days) FIXED-ASSET TURNOVER TOTAL ASSET TURNOVER PROFITABILITY RATIOS RETURN ON TOTAL ASSET RETURN ON NET WORTH PROFIT MARGIN ON SALES LEVERAGE RATIO DEBT RATIO 3.51 1.75 8.00 29.20 N/A 14.93 3.75 0.15 0.20 0.04 0.25 2017 2018 2019 INDUSTRY 2.00 2.50 1.04 1.16 6.18 39.82 N/A 10.58 12.56 2.81 2.89 ? ? ? 0.08 0.03 0.14 0.04 0.03 0.01 0.39 0.33 1.90 0.81 ? ? ? 10.84 2.27 0.10 0.18 0.05 0.43 2.00 1.50 4.25 29.0 30.0 13.30 3.00 0.10 0.15 0.03 0.30 AUSING LTD INCOME STATEMENT AND BALANCE SHEET 2014 INCOME STATEMENT NET SALES COGS GROSS PROFIT ADMIN, SELLING & INTEREST DEPRECIATION MISCELLANEOUS NET INCOME BEFORE TAX TAXES @ 40% NET INCOME BALANCE SHEET CASH ACCOUNTS RECEIVABLE INVENTORY TOTAL CURRENT ASSETS LAND & BUILDING MACHINERY OTHER FIXED ASSETS TOTAL ASSETS BANK NOTES PAYABLE ACCOUNTS PAYABLE ACCRUALS TOTAL CURRENT LIABILITIES MORTGAGE COMMON STOCK RETAINED EARNINGS TOTAL LIABILITY & EQUITY $5,000,000 $4,000,200 $ 999,800 $ 521,467 $ 80,000 EA GA 2018 2019 2017 $4,400,000| $ 5,600,000| $ 4,500,000 $3,400,000 $ 4,500,000 | $ 3,500,000 $1,000,000 $1,100,000 $1,000,000 $ 849,667 $ 519,000 $ 72,000 $ 582,000 $ 105,000 $ 80,000 77,000 $ 71,500 93,333 $ 337,500 $ 135,000 $ 202,500 $ 65,000 $ 93,000 $333,333 $ 220,000 $ $ 133,333 $ 88,000 $ 37,333 $ 200,000 $ 132,000 $ 56,000 EA EA EA $ $ 285,000 $ 575,000 50,000 $ 40,000 $ 900,000 $ 900,000 $ 100,000 $ 51,000 $1,335,000 $1,566,000 $ EA GA 2014 2017 $ 2018 2019 90,000 $ 70,000 $ 600,000 100,000 $ 120,000 $ 400,000 $ 480,000 $ $ 550,000 $ $ 500,000 $ 1,000,000 $ 1,490,000 $ 600,000 $ 800,000 $ 900,000 $ 1,150,000 $ 1,570,000 $ 100,000 $ 90,000 $ 217,000 $ 221,000 150,000 $ 260,000 $ 202,000 $ 179,000 $ 85,000 $ 66,000 $ 27,000 $ 15,000 $ 1,335,000 $ 1,566,000 | $ 1,936,000| $ 1,985,000 $ 47,000 $ 53,000 $ 110,000 $ 473,000 $ 156,000 $ 171,500 $ 233,800 $319,000 $ 82,000 $ 350,500 $ 252,200 $ 34,300 $ 596,000 $ 826,300 $ 36,000 $ 33,000 $ 1,150,000 $ 867,000 $ 154,000 $ 258,700 $1,936,000 $1,985,000
Expert Answer:
Answer rating: 100% (QA)
To analyze the given data and calculate the omitted values we will focus on the ratios provided in the table Lets start by calculating the missing val... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
What Is Your Advice? 1. What would you suggest to Tyler to improve the restaurants operational efficiency? Examine the businesss inputs, processing, and outputs. Formulate recommendations to...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
What is the future value of the following cash flows, given an appropriate discount rate of 7.74% (to the nearest penny)? Year 1 Year 2 Year 3 Year 4 Year 5 $2,005 $4,054 $6,159 $8,532 $11,985
-
In Problem 3.60, determine the perpendicular distance between cable CF and the line joining Points D and B. PROBLEM 3.60 The triangular plate ABC is supported by ball-and-socket joints at B and D and...
-
Suppose you find evidence that high school dropout workers are more likely to retire at age 62 than are college-educated workers. You conclude that these workers do so because they are more...
-
You are given a timewheel that is initially empty. The timewheel processes events, each of which has a generation time and a release time. Show the state of the timewheel (events and their order)...
-
Castle Lager has just purchased the Jacksonville Brewery. The brewery is two years old and uses absorption costing. It will sell its product to Castle Lager at $ 47 per barrel. Peter Bryant, Castle...
-
Following are the transactions of a new company called Pose-for-Pics. August 1 M. Harris, the owner, invested $12,500 cash and $53,750 of photography equipment in the company in exchange for common...
-
At the beginning of the year, Anna began a calendar-year business and placed in service the following assets during the year: Date Acquired 1/30 Cost Asset Basis $ 58,000 $ 62,000 $ 105,000 $ 440,000...
-
Do I have to tell you to note the speed increases? Everything is happening so much faster. What effect does that have on Marketing? Do a last practice essay on 3 areas: What must you do to market...
-
A magnetic dipole antenna is used to detect an electromagnetic wave. The antenna is a coil of 46.0 turns with radius 5.00 cm. The EM wave has frequency 849 kHz, electric field amplitude 0.510 V/m,...
-
You currently have $247,887.43 to deposit. Your banker offers you an annuity paying $25,000 per year for the next 18 years. What implied rate is the banker offering? [Present the answer rounded to...
-
Simple Interest Problem: How much money is in an account after 6 years, if you initially deposit $838, with a simple interest of 5%? Interest is added annually.
-
Your cars 40.0-W headlight and 2.70-kW starter are ordinarily connected in parallel in a 12.0-V system. What power would one headlight and the starter consume if connected in series to a 12.0-V...
-
An FM radio tuning circuit has a coil with an inductance of 0 . 0 0 3 mH . What 1 point is the value of the capacitance if the set is tuned to 9 8 MHz ?
-
15. The average value of a half-wave rectified voltage with a peak value of 200 V is (5 Points) 63.7 V 127.2 V 141 V O V
-
Define the essential properties of the following types of operating systems: a. Batch b. Interactive c. Time sharing d. Real time e. Network f. Parallel g. Distributed h. Clustered i. Handheld
-
Tom has a successful business with $100,000 of income in 2012. He purchases one new asset in 2012, a new machine which is 7-year MACRS property and costs $25,000. If you are Tom's tax advisor, how...
-
Dr. George E. Beeper is a single taxpayer. He lives at 45 Mountain View Dr., Apt. 321, Spokane, WA 99210. Dr. Beeper's Social Security number is 775-88-9531. Dr. Beeper works for the Pine Medical...
-
Rebecca and Walter Bunge have been married for 5 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Rebecca is a homemaker and Walt is a high school teacher. Rebecca's Social...
-
Name three or more branches of Earth science, and describe the focus of each.
-
Earth has remained about the same size since it formed 4.6 billion years ago. What does this suggest about the rate of seafloor spreading compared to the rate of subduction?
-
Why is Earth science an integrated science?
Study smarter with the SolutionInn App