Question: Background: This assignment uses a company case study for financial statement analysis. Students are required to solve financial ratios and analyze these ratios using a

Background:

This assignment uses a company case study for financial statement analysis. Students are required to solve financial ratios and analyze these ratios using a time series trend. The students must identify strengths and weakness of the company and make recommendations to the manager of the company.

Instructions:

Part A: Use 2017 and 2016 comparative income statements and balance sheets for Blackwater Falls Company provided in the following tab. Calculate the following ratios for 2017:

working capital

current ratio

quick ratio

days sales receivable

inventory turnover

debt to equity

times-interest-earned

return on assets (ROA)

earnings per share (EPS)

price to earnings (PE)

Note: All work must be completed in EXCEL using formulas for grading. (Answers submitted in Word or without formulas in Excel will receive a zero.) The question only specifically asks for 2074 ratios. However, in order to do a thorough analysis in part b you may need to compute 2016 ratios as well for comparisons when applicable. (There are some ratios that you will not be able to compute from the prior year because of a lack of data.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

FSA memo, ratios are done hope this helps here is the instructions and incomplete ratios Background: This assignment uses a company case study for financial statement analysis. Students are required...

Background: This assignment uses a company case study for financial statement analysis. Students are required to solve financial ratios and analyze these ratios using a time series trend. The...

Hello Finstat. I have really appreciated your help so far. Can you help with the attached? From what I can tell and what the instructor has told us is that this is less involved than the previous...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

Prepare the financial analysis to support your decision between bankruptcy,voluntary reorganization,and Chapter11reorganization.It must be complete and prepared in a professional level,with the...

FORECASTED INCOME STATEMENT YEAR 1 YEAR 2 Revenue Cost of Sales Gross Margin Operating Expenses Advertising Equipment Rental wages office Rent Lutilities insurance Expense Depreciation Operating...

Assignment #2 - Case Study: Forecasting Financial Statements & Ratios Students will construct a set of forecasted financial statements and calculate a set of financial ratios for a start-up business...

I need final page completed regarding PV, capital spending, pv amount, and npv. Calibri A A 29 Wrap Text Custom Paste A 120 B IU -A- Merge & Center $ % ) 20 X fx 018*0.1 B E San Diego Pleasure Craft...

GROUP PROJECT: ALWASL PLUMBING COMPANY AlWasl Plumbing Company (WPC) has approached Etihad Bank (EB) with a request for AED2,000,000 in credit facilities to finance its working capital needs. EBs...

0:0V GROUP PROJECT ALWASL PLUMBING COMPANY LAST DATLOSASSON Max 95.2022 This des There muliere were 1 Det 2 Comment Conde Monday at the name or sed at ane in this edersen puede De nog steedt omnes...

A fixed mass of an ideal gas is heated from 50 to 80C at a constant volume of (a) 1 m3 and (b) 3 m3. For which case do you think the energy required will be greater? Why?

Consider the reaction N2(g) + O2(g) 2NO(g) Given that G for the reaction at 25C is 173.4 kJ/mol, (a) calculate the standard free energy of formation of NO, and (b) calculate KP of the reaction. (c)...

In a recent opinion poll a sample of 1,200 adults (at least 20 years old) was surveyed. Of these adults, 768 were married, 684 were female and there were 459 married females. Construct a contingency...

SMART goal for bone fractures

Understand some of the infl uences on the business environment that have changed the approaches to employing people.

Design a job advertisement.

10-20 Describe the six features of social commerce. Provide an example for each feature describing how a business could use that feature for selling to consumers on line.