Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone please provide the project report and the calculations. 1. been on financial public farm from Dow Jones 30. retrieve financial statements from finance.yahoo.com.

Can someone please provide the project report and the calculations.
1. been on financial public farm from Dow Jones 30. retrieve financial statements from finance.yahoo.com.
2. calculate the following ratios for your chosen chosen firm for 2018 and 2019.

Liquidity ratios: Current Ratio, Quick Ratio, And Cash Ratio

Solvency Ratios: total debt ratio, Equity equity ratio, Times interest earned ratio

Turnover ratios: inventory turnover, receivables turnover, total asset turnover

Profitability ratio: profit margin, return on assets(ROA), Return of Equity(ROE)

Market values ratios: Price earnings ratio, Market to book ratio

3. Investigate the firms financial condition in 2019( by comparing with 2018) in terms of liquidity, solvency, turnover, probability, and market values by analyzing the calculated ratios. how the firms performance changed through time? based on your analysis comment on the future prospect of the farm from an investor's viewpoint. image text in transcribed
image text in transcribed
image text in transcribed
Ratio Analysis Project FIN 343: Managerial Finance . Upload your Project Report (word/pdf) and Calculation (excel) to Canvas before the due day No hard copy is accepted Late submission will be penalized by deducting 10-20% of the project grade This is an individual assignment. The project is an exercise of fundamental analysis of a firm using ratios. You are expected to calculate a number of ratios for a firm and analyze its financial condition. Upload 2 files on Canvas: Project Report (word/pdf) and Calculation (excel). 1. Pick a non-financial public firm from Dow Jones 30. Retrieve financial statements from finance.yahoo.com. 2. Calculate the following ratios for your chosen firm for 2018 and 2019. Turnover Ratios: Inventory Turnover Receivables Turnover Total Asset Turnover Liquidity Ratios: Solvency Ratios: Current Ratio Total Debt Ratio Quick Ratio Debt-equity Ratio Cash Ratio Times Interest Earned Ratio Profitability Ratios: Market values Ratios: Profit Margin Price-earnings Ratio Return on Assets (ROA) Market-to-book Ratio Return on Equity (ROE) I 3. Investigate the firm's financial condition in 2019 (by comparing with 2018) in terms of its Liquidity, Solvency. Turnover, Profitability, and Market Values by analyzing the calculated ratios. How the firm's performance changed through time? Based on your analysis, comment on the future prospect of the firm from an investor's viewpoint. Show all your works/calculation in an excel file (Questions 1 and 2). The required financial statements (Income Statement and Balance Sheet) must be presented in excel; calculate all the ratios from those data using excel formula Use a word/pdf file for the analysis part (Question 3). There is no page limit for the Project Report. The length of the report depends on the work needed in completing each of the components of the project. Add to watchlist Mirae Asset Tiger Dow Jones 30 ETF (245340.KS) KSE - KSE Detayed Price Currency in KRW 18,820.00 +170.00 (+0.91%) As of 11:16AM KST. Market open Summary Chart Conversations Historical Data Profile Options Holdings Performance Risk Previous Close 18,650.00 Net Assets N/A 10 SD IM 6M YTD 1y5Y Max Full screen 1000 Open 18,840.00 NAV N/A 18,800.00 16.79333 Bid N/A N/A PE Ratio (TTM) N/A Yield N/A 18.706,67 Days Range N/A N/A N/A 18.745.00 18,840.00 11,340.00 18,840,00 8,034 1,050.00 52 Week Range YTD Daily Total Return Beta (SY Monthly Expense Ratio N/A Volume N/A (nes) 09 AM 11 AM 01 PM 0 PM Avg. Volume N/A Inception Date N/A Ratio Analysis Project FIN 343: Managerial Finance . Upload your Project Report (word/pdf) and Calculation (excel) to Canvas before the due day No hard copy is accepted Late submission will be penalized by deducting 10-20% of the project grade This is an individual assignment. The project is an exercise of fundamental analysis of a firm using ratios. You are expected to calculate a number of ratios for a firm and analyze its financial condition. Upload 2 files on Canvas: Project Report (word/pdf) and Calculation (excel). 1. Pick a non-financial public firm from Dow Jones 30. Retrieve financial statements from finance.yahoo.com. 2. Calculate the following ratios for your chosen firm for 2018 and 2019. Turnover Ratios: Inventory Turnover Receivables Turnover Total Asset Turnover Liquidity Ratios: Solvency Ratios: Current Ratio Total Debt Ratio Quick Ratio Debt-equity Ratio Cash Ratio Times Interest Earned Ratio Profitability Ratios: Market values Ratios: Profit Margin Price-earnings Ratio Return on Assets (ROA) Market-to-book Ratio Return on Equity (ROE) I 3. Investigate the firm's financial condition in 2019 (by comparing with 2018) in terms of its Liquidity, Solvency. Turnover, Profitability, and Market Values by analyzing the calculated ratios. How the firm's performance changed through time? Based on your analysis, comment on the future prospect of the firm from an investor's viewpoint. Show all your works/calculation in an excel file (Questions 1 and 2). The required financial statements (Income Statement and Balance Sheet) must be presented in excel; calculate all the ratios from those data using excel formula Use a word/pdf file for the analysis part (Question 3). There is no page limit for the Project Report. The length of the report depends on the work needed in completing each of the components of the project. Add to watchlist Mirae Asset Tiger Dow Jones 30 ETF (245340.KS) KSE - KSE Detayed Price Currency in KRW 18,820.00 +170.00 (+0.91%) As of 11:16AM KST. Market open Summary Chart Conversations Historical Data Profile Options Holdings Performance Risk Previous Close 18,650.00 Net Assets N/A 10 SD IM 6M YTD 1y5Y Max Full screen 1000 Open 18,840.00 NAV N/A 18,800.00 16.79333 Bid N/A N/A PE Ratio (TTM) N/A Yield N/A 18.706,67 Days Range N/A N/A N/A 18.745.00 18,840.00 11,340.00 18,840,00 8,034 1,050.00 52 Week Range YTD Daily Total Return Beta (SY Monthly Expense Ratio N/A Volume N/A (nes) 09 AM 11 AM 01 PM 0 PM Avg. Volume N/A Inception Date N/A

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditory Cognition And Human Performance: Research And Applications

Authors: Carryl L. Baldwin

1st Edition

0415325943, 978-0415325943

More Books

Students also viewed these Accounting questions

Question

How will these issues affect the grade levels you will teach?

Answered: 1 week ago