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.

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