Posted: July 14th, 2019
MBA6010 Assignments
Week 1 assignment 4
For each of the five years of the provided financial statements, calculate and analyze MNQ Company’s thirteen financial ratios:
Current ratio
Quick ratio
Cash ratio
Total debt ratio
Times interest earned ratio
Cash coverage ratio
Inventory turnover ratio
Receivables turnover ratio
Profit margin
Return on assets
Return on equity
Price-earnings ratio
Market-to-book ratio
Additionally, critique these numbers. Do any patterns emerge with these ratios? Please explain.
Submit your answer in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week 2 Assignment 3
Based on the financial statements provided in
SU_MBA6010_Final_Project_Information.xls in the Doc Sharing area, use
the dividend growth model to calculate the intrinsic value of MNQ
Companyâs common stock in 2008.
Determine whether the stock is undervalued, overvalued, or fully valued. Justify the assumptions that you make.
Submit your answers in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week 3 Assignment 3
Assume that MNQ Company is looking to undertake a new project. The cash
flows and applicable discount rate are provided in the third tab of
SU_MBA6010_Final_Project_Information.xls in the Doc Sharing area.
Calculate the IRR, NPV, MIRR, and payback period of the project.
The company has a three-year payback cutoff period for projects.
Determine if it makes financial sense for the company to undertake the
project. Justify your decision.
Submit your answers in a 5- to 7-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week-4 Assignment-3
Based on the data on the fourth tab of
SU_MBA6010_Final_Project_Information.xls, provided in the Doc Sharing
area, create an equally weighted portfolio of all ten stocks (including
MNQ Company and the other nine stocks) and estimate the beta of the
portfolio.
Using the CAPM, determine the required rate of return for the portfolio.
Submit your answers in a 3- to 5-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week 5 Assignment 2
⢠Locate ten organizations that currently pay a common stock cash
dividend. Go to the Finance Web link provided in the Webliography, enter
the ticker symbol of an S&P 500 company in the quote box, and see
whether it indicates that the company pays a dividend.
⢠Calculate the organizations’ cost of equity using the dividend yield
plus growth rate approach and the security market line (SML) model
approach.
⢠For each organization, show how the cost of equity differs based on the two approaches.
Refer to the Web link Finance in the Webliography for information on beta of stocks.
Submit your answers in a 2- to 3-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week 5 Assignment 3
MNQ Company’s pretax cost of debt is 7 percent. Refer to the data on the
first and second tabs of the spreadsheet
SU_MBA6010_Final_Project_Information.xls provided in the Doc Sharing
area. For this part of the assignment only, assume that MNQ Company’s
book value capital structure weights equal its market value capital
structure weights.
Estimate the company’s cost of capital for 2008.
Submit your answers in a 3- to 5-page Microsoft Word document and your calculations in a Microsoft Excel sheet.
Week 6 Assignment 2
Refer to the data on the first and second tabs of
SU_MBA6010_Final_Project_Information.xls provided in the Doc Sharing
area. Assume that all of MNQ Company’s sales are credit sales.
⢠Calculate and critique MNQ Company’s cash conversion and operating cycles from 2004 to 2008.
⢠Create a 10- to 15-slide Microsoft PowerPoint presentation bringing together your findings from Weeks 1 through 6.
Submit your answers in a 3- to 5-page Microsoft Word document, your
calculations in a Microsoft Excel sheet, and your presentation in a
Microsoft PowerPoint file.