You have been hired to be the assistant to the Chief Financial Officer of RidgeRunner Mountain...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have been hired to be the assistant to the Chief Financial Officer of RidgeRunner Mountain Bikes Inc.. The CFO has been asked to provide a report to the Board of Directors on the performance of the company for the 2020 year. The CFO has asked you to analyze the following financial data for the 2020 and 2019 years to help him answer the following questions. Balance Sheets Income Assets Cash Short-term investments Accounts receivable Inventories Total current assets Gross fixed assets Less: accumulated depreciation Net fixed assets Total assets Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt $ 2020 7,282 $ 51,000 652,160 1,307,360 2,017,802 1,273,950 263,160 1,010,790 $ 3,028,592 2019 9,000 48,600 351,200 715,200 1,124,000 491,000 146,200 344,800 $ 1.468.800 2020 2019 $ 324,000 $ 145,600 720,000 200,000 284,960 136,000 1,328,960 481,600 1.000.000 323 432 Statements Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity Sales Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net income 1,328,960 1,000,000 460,000 239,632 699,632 $3,028,592 2020 $ 5,834,400 4,900,000 600,000 116,960 5,616,960 217,440 126,000 91,440 36,576 $ 54,864 481,600 323,432 460,000 203,768 663,768 $1.468.800 $ 2019 $ 3,432,000 2,864,000 340,000 18,900 3,222,900 209,100 62,500 146,600 58,640 87.960 4 Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity Sales Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net income 1,328,960 1,000,000 460,000 239,632 699,632 $3,028,592 2020 $ 5,834,400 4,900,000 600,000 116,960 5,616,960 217,440 126,000 91,440 36,576 $ 54,864 481,600 323,432 460,000 203,768 663,768 $1.468.800 $ 2019 $ 3,432,000 2,864,000 340,000 18,900 3,222,900 209,100 62,500 146,600 58,640 87.960 4 Dividends paid Other Data Stock price WACC Cash Short term investments Common Size Balance Sheets Assets Accounts receivable Inventories Total current assets Total assets Liabilities and Equity Accounts payable $ Notes payable Accruals Total current liabilities Long-term debt Common stock Retained earnings Total equity Total liabilities and equity $ Common Size Income Statement Sales 10,000 2018 7.00 10% 2020 2020 $ 2017 8.50 10% 2019 Industry 0.6% 3.3% 23.9% 48.7% 76.5% 100.0% 2020 2019 100.0% 0.3% 0.3% 22.4% 41.2% 64.1% 100.0% 2019 Industry 9.9% 11.9% 13.6% 2.4% 9.3% 9.5% 32.8% 22.0% 31.3% 13.9% 45.2% 100.0% 23.7% 26.3% 20.0% 30.0% 50.0% 100.0% Industry 100.0% Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net Income Financial Ratios Current Quick Inventory Turnover Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover Debt ratio TIE Profit Margin Return on Assets Return on Equity Price/Earnings 2020 83.4% 9.9% 0.6% 93.9% 6.1% 1.8% 4.3% 1.7% 2.6% 2019 2.3X 0.8X 4.0X 37 10.0X 2.3X 54.8 3.3X 2.6% 6.0% 13.3% 9.7X 84.5% 4.4% 4.0% 92.9% 7.1% 1.1% 5.9% 2.4% 3.6% Industry Avg 2.7X 1.0X 6.1X 32 7.0X 2.5X 50.0 6.2X 3.6% 9.0% 17.9% 16.2X Questions: 1. What was RidgeRunner's NOPAT for 2020? 2. What was its Free Cash Flow for 2020? What is Free Cash Flow? What can the company use Free Cash Flow for? 3. What was its Return on Invested Capital (ROIC) for 2020? Compared to the company's WACC, did the company's growth add value for the year? 4. What was the company's Economic Value Added (EVA) for 2020? 5. a. Calculate the Market Value Added (MVA) for 2020 and 2019. b. Did the company increase its MVA between 2019 and 2020? 6. Perform Ratio Analysis for 2020 year: a. Calculate the Current and Quick ratios. Has the company's liquidity position improved or worsened? b. Calculate the Inventory Turnover, Days Sales Outstanding, Fixed Asset Turnover, Total Asset Turnover ratios. How well has the company managed its assets? c. Calculate the Debt ratio, Times Interest Earned ratios and compare to industry average. What can you conclude about its debt management? d. Calculate the Profit Margin, Return on Assets, Return on Equity ratios. - How has the company's profitability changed? e. Calculate the P/E Ratio. What can you conclude about what investors think about the company when compared to Industry? aina the Bolanos Shoot for 2020 7. Perform a common size analysis on the Balance Sheet for 2020. a. What has happened to the assets and liabilities between 2020 and 2019? b. How does the company compare to Industry Average? 8. Perform a common size analysis on the Income Statement. a. What does the percentages tell you about the profitability of the company (i.e. how is it doing with regard to controlling its expenses)? 9. What are the potential problems or limitations of financial ratio analysis? Part B. Time Value of Money Analysis 1. What's the future value of $150 after 3 years if it earns 12%, annual compounding? 2. What's the present value of $200 to be received in 3 years if the interest rate is 12%, annual compounding? 3. What annual interest rate would cause $200 to grow to $231.53 in 3 years? 4. If a company's sales are growing at a rate of 10% annually, how long will it take sales to double? 5. What's the difference between an ordinary annuity and an annuity due? 6. What is the present value of a 3-year, $120 ordinary annuity if the annual interest rate is 8%? 7. For Question #6 What is its future value? 8. For Question #6 What would the present value be if it was an annuity due? 9. A 5-year $150 ordinary annuity has an annual interest rate of 8%. What is its present value? 10. For Question #9 What would the present value be if it was a 10-year annuity? 11. For Question #9 What would the present value be if this was a perpetuity? 12. A 25-year-old student wants to save for her retirement. At the end of each year, she invests $5,000 in a brokerage account with an expected annual return of 7%. If she keeps saving in this manner, how much will she have accumulated at age 65? 13. If the same student waited until she was 40 years old to begin saving $5,000 at the end of each year as in #12, how much would she have at age 65? 14. Using your answer for Question #12, how much would she need to save each year if she started saving at age 40 to accumulate the same amount at age 65 as she would have had if she had started saving at age 25? 15. What is the present value of the following uneven cash flow stream? The annual interest rate is 8%. 0 1 + 0 100 200 300 -150 16. You borrow $30,000 to buy a car. The bank charges an interest rate of 5% on the loan. If 2 3 4 Years 4 9. A 5-year $150 ordinary annuity has an annual interest rate of 8%. What is its present value? 10. For Question #9 What would the present value be if it was a 10-year annuity? 11. For Question #9 What would the present value be if this was a perpetuity? 12. A 25-year-old student wants to save for her retirement. At the end of each year, she invests $5,000 in a brokerage account with an expected annual return of 7%. If she keeps saving in this manner, how much will she have accumulated at age 65? 13. If the same student waited until she was 40 years old to begin saving $5,000 at the end of each year as in #12, how much would she have at age 65? 14. Using your answer for Question # 12, how much would she need to save each year if she started saving at age 40 to accumulate the same amount at age 65 as she would have had if she had started saving at age 25? 15. What is the present value of the following uneven cash flow stream? The annual interest rate is 8%. 0 1 2 4 3 + 0 100 200 300 -150 16. You borrow $30,000 to buy a car. The bank charges an interest rate of 5% on the loan. If the loan is to be repaid in equal amounts over 5 years, how much are the annual payments? Years You have been hired to be the assistant to the Chief Financial Officer of RidgeRunner Mountain Bikes Inc.. The CFO has been asked to provide a report to the Board of Directors on the performance of the company for the 2020 year. The CFO has asked you to analyze the following financial data for the 2020 and 2019 years to help him answer the following questions. Balance Sheets Income Assets Cash Short-term investments Accounts receivable Inventories Total current assets Gross fixed assets Less: accumulated depreciation Net fixed assets Total assets Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt $ 2020 7,282 $ 51,000 652,160 1,307,360 2,017,802 1,273,950 263,160 1,010,790 $ 3,028,592 2019 9,000 48,600 351,200 715,200 1,124,000 491,000 146,200 344,800 $ 1.468.800 2020 2019 $ 324,000 $ 145,600 720,000 200,000 284,960 136,000 1,328,960 481,600 1.000.000 323 432 Statements Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity Sales Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net income 1,328,960 1,000,000 460,000 239,632 699,632 $3,028,592 2020 $ 5,834,400 4,900,000 600,000 116,960 5,616,960 217,440 126,000 91,440 36,576 $ 54,864 481,600 323,432 460,000 203,768 663,768 $1.468.800 $ 2019 $ 3,432,000 2,864,000 340,000 18,900 3,222,900 209,100 62,500 146,600 58,640 87.960 4 Total current liabilities Long-term debt Common stock (100,000 shares) Retained earnings Total equity Total liabilities and equity Sales Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net income 1,328,960 1,000,000 460,000 239,632 699,632 $3,028,592 2020 $ 5,834,400 4,900,000 600,000 116,960 5,616,960 217,440 126,000 91,440 36,576 $ 54,864 481,600 323,432 460,000 203,768 663,768 $1.468.800 $ 2019 $ 3,432,000 2,864,000 340,000 18,900 3,222,900 209,100 62,500 146,600 58,640 87.960 4 Dividends paid Other Data Stock price WACC Cash Short term investments Common Size Balance Sheets Assets Accounts receivable Inventories Total current assets Total assets Liabilities and Equity Accounts payable $ Notes payable Accruals Total current liabilities Long-term debt Common stock Retained earnings Total equity Total liabilities and equity $ Common Size Income Statement Sales 10,000 2018 7.00 10% 2020 2020 $ 2017 8.50 10% 2019 Industry 0.6% 3.3% 23.9% 48.7% 76.5% 100.0% 2020 2019 100.0% 0.3% 0.3% 22.4% 41.2% 64.1% 100.0% 2019 Industry 9.9% 11.9% 13.6% 2.4% 9.3% 9.5% 32.8% 22.0% 31.3% 13.9% 45.2% 100.0% 23.7% 26.3% 20.0% 30.0% 50.0% 100.0% Industry 100.0% Cost of goods sold Other expenses Depreciation Total operating costs EBIT Interest expense EBT Taxes (40%) Net Income Financial Ratios Current Quick Inventory Turnover Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover Debt ratio TIE Profit Margin Return on Assets Return on Equity Price/Earnings 2020 83.4% 9.9% 0.6% 93.9% 6.1% 1.8% 4.3% 1.7% 2.6% 2019 2.3X 0.8X 4.0X 37 10.0X 2.3X 54.8 3.3X 2.6% 6.0% 13.3% 9.7X 84.5% 4.4% 4.0% 92.9% 7.1% 1.1% 5.9% 2.4% 3.6% Industry Avg 2.7X 1.0X 6.1X 32 7.0X 2.5X 50.0 6.2X 3.6% 9.0% 17.9% 16.2X Questions: 1. What was RidgeRunner's NOPAT for 2020? 2. What was its Free Cash Flow for 2020? What is Free Cash Flow? What can the company use Free Cash Flow for? 3. What was its Return on Invested Capital (ROIC) for 2020? Compared to the company's WACC, did the company's growth add value for the year? 4. What was the company's Economic Value Added (EVA) for 2020? 5. a. Calculate the Market Value Added (MVA) for 2020 and 2019. b. Did the company increase its MVA between 2019 and 2020? 6. Perform Ratio Analysis for 2020 year: a. Calculate the Current and Quick ratios. Has the company's liquidity position improved or worsened? b. Calculate the Inventory Turnover, Days Sales Outstanding, Fixed Asset Turnover, Total Asset Turnover ratios. How well has the company managed its assets? c. Calculate the Debt ratio, Times Interest Earned ratios and compare to industry average. What can you conclude about its debt management? d. Calculate the Profit Margin, Return on Assets, Return on Equity ratios. - How has the company's profitability changed? e. Calculate the P/E Ratio. What can you conclude about what investors think about the company when compared to Industry? aina the Bolanos Shoot for 2020 7. Perform a common size analysis on the Balance Sheet for 2020. a. What has happened to the assets and liabilities between 2020 and 2019? b. How does the company compare to Industry Average? 8. Perform a common size analysis on the Income Statement. a. What does the percentages tell you about the profitability of the company (i.e. how is it doing with regard to controlling its expenses)? 9. What are the potential problems or limitations of financial ratio analysis? Part B. Time Value of Money Analysis 1. What's the future value of $150 after 3 years if it earns 12%, annual compounding? 2. What's the present value of $200 to be received in 3 years if the interest rate is 12%, annual compounding? 3. What annual interest rate would cause $200 to grow to $231.53 in 3 years? 4. If a company's sales are growing at a rate of 10% annually, how long will it take sales to double? 5. What's the difference between an ordinary annuity and an annuity due? 6. What is the present value of a 3-year, $120 ordinary annuity if the annual interest rate is 8%? 7. For Question #6 What is its future value? 8. For Question #6 What would the present value be if it was an annuity due? 9. A 5-year $150 ordinary annuity has an annual interest rate of 8%. What is its present value? 10. For Question #9 What would the present value be if it was a 10-year annuity? 11. For Question #9 What would the present value be if this was a perpetuity? 12. A 25-year-old student wants to save for her retirement. At the end of each year, she invests $5,000 in a brokerage account with an expected annual return of 7%. If she keeps saving in this manner, how much will she have accumulated at age 65? 13. If the same student waited until she was 40 years old to begin saving $5,000 at the end of each year as in #12, how much would she have at age 65? 14. Using your answer for Question #12, how much would she need to save each year if she started saving at age 40 to accumulate the same amount at age 65 as she would have had if she had started saving at age 25? 15. What is the present value of the following uneven cash flow stream? The annual interest rate is 8%. 0 1 + 0 100 200 300 -150 16. You borrow $30,000 to buy a car. The bank charges an interest rate of 5% on the loan. If 2 3 4 Years 4 9. A 5-year $150 ordinary annuity has an annual interest rate of 8%. What is its present value? 10. For Question #9 What would the present value be if it was a 10-year annuity? 11. For Question #9 What would the present value be if this was a perpetuity? 12. A 25-year-old student wants to save for her retirement. At the end of each year, she invests $5,000 in a brokerage account with an expected annual return of 7%. If she keeps saving in this manner, how much will she have accumulated at age 65? 13. If the same student waited until she was 40 years old to begin saving $5,000 at the end of each year as in #12, how much would she have at age 65? 14. Using your answer for Question # 12, how much would she need to save each year if she started saving at age 40 to accumulate the same amount at age 65 as she would have had if she had started saving at age 25? 15. What is the present value of the following uneven cash flow stream? The annual interest rate is 8%. 0 1 2 4 3 + 0 100 200 300 -150 16. You borrow $30,000 to buy a car. The bank charges an interest rate of 5% on the loan. If the loan is to be repaid in equal amounts over 5 years, how much are the annual payments? Years
Expert Answer:
Answer rating: 100% (QA)
Part A Financial Analysis 1 NOPAT for 2020 NOPAT EBIT1 Tax Rate NOPAT 2174401 040 130464 2 Free Cash Flow for 2020 Free Cash Flow NOPAT Depreciation C... View the full answer
Related Book For
Principles of Information Systems
ISBN: 978-1133629665
11th edition
Authors: Ralph Stair, George Reynolds
Posted Date:
Students also viewed these accounting questions
-
You have been hired to help Mary with her forecasting problem. Write her a memo that summarizes her efforts to date and that recommends a course of action to her. Be sure your memo addresses the...
-
You have been hired to develop group support software. Describe the features you would include in your new GSS software.
-
You have been hired as a marketing research analyst by Burger King. Your boss, the market manager, is wondering what statistical analysis should be conducted to explain the patronage of Burger King...
-
Hardie Lord, Helen Murvis's boss, is not convinced that Helen used the correct decision technique. Hardie believes that Helen should use a coefficient of realism of 0.75 in determining the best...
-
It can be shown that for any data y 1 , y 2 , c , y n the smallest value for is obtained by setting M = y. Explain why this implies that the fitted values in ANOVA are the sample averages of the...
-
Refer to Problem 16-30. a. Use the linear trend model (without transformation) for the first 15 months and provide a cash balance forecast for month 16. Then make the t2 transformation and develop a...
-
Among your colleagues in class, identify a term or phrase italicized in this chapter that you think is the most significant from your reading. Absent team consensus, then just provide your...
-
Cost estimation, cumulative average-time learning curve. Cost estimation, cumulative average-time learning curve. The Nautilus Company, which is under contract to the U.S. Navy, assembles troop...
-
IN ACFR, if the legal debt margin is steady increase in last ten fiscal years what it means
-
Jake, Inc., is a manufacturer that just completed the first month of a new fiscal year. After reviewing the variances of actual results from the master budget, the finance department provided an...
-
Calculate the following and explain the answers with favorable or Unfavorable. 1) Complete the Flexible budget sheet. 2) Profit Variance? 3) Total Revenue Variance 4) Revenue Volume Variance? 5)...
-
A current-carrying wire is bent into a circular loop of radius \(R\) and lies in an \(x y\) plane. A uniform external magnetic field in the \(+z\) direction exists throughout the plane of the loop....
-
A parallel-plate capacitor with a plate area of \(50 \mathrm{~mm}^{2}\) and air between the plates can hold \(5.5 \mathrm{pC}\) of charge per volt of potential difference across its plates. When a...
-
When a dielectric slab completely fills the space between the plates of a parallel-plate capacitor, the magnitude of the bound charge is one-fourth the magnitude of the free charge. (a) What is the...
-
In Assignment 5.7, you identified all of the requirements for a ceremonial marriage in your state. In this assignment, you are to interview someone who was married in your state in order to determine...
-
You are given three bars of metal. Two of them are magnets, and the third is made of a magnetic material but is not magnetized. Describe how, using only the three bars, you could determine which of...
-
When converting a semimonthly salary rate to an hourly rate, the payroll processor can most easily: O a. annualize the salary and then divide by 40 to get the hourly rate. O b. use the table of...
-
It is possible to investigate the thermo chemical properties of hydrocarbons with molecular modeling methods. (a) Use electronic structure software to predict cHo values for the alkanes methane...
-
Identify two approaches to securing the trans- mission of confidential data.
-
You have decided to become an IS entrepreneur and develop applications for the iPhone and other mobile devices. Describe what applications you would develop and how you would do it.
-
Give three examples of an IS vendor.
-
Why is macroeconomic forecasting so difficult? Does this difficulty mean economics is a worthless field of study?
-
Which of the following statements are positive in nature and which are normative? a. A tax cut will raise interest rates. b. A reduction in the payroll tax would primarily benefit poor and...
-
Graph the behavior of the civilian unemployment rate from 1961 until the present using monthly data. Can you see the periods of recession that occurred in 19691970, 19731975, 1980, 19811982,...
Study smarter with the SolutionInn App