MBA6010 Assignments
Week 1 task Four For every of the 5 years of the offered monetary statements, calculate and analyze MNQ Firm's 13 monetary ratios: Present ratio Fast ratio Money ratio Whole debt ratio Instances curiosity earned ratio Money protection ratio Stock turnover ratio Receivables turnover ratio Revenue margin Return on property Return on fairness Worth-earnings ratio Market-to-book ratio Moreover, critique these numbers. Do any patterns emerge with these ratios? Please clarify. Submit your reply in a 5- to 7-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week 2 Task Three Primarily based on the monetary statements offered in SU_MBA6010_Final_Project_Information.xls within the Doc Sharing space, use the dividend development mannequin to calculate the intrinsic worth of MNQ Company’s widespread inventory in 2008. Decide whether or not the inventory is undervalued, overvalued, or absolutely valued. Justify the assumptions that you simply make. Submit your solutions in a 5- to 7-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week Three Task Three Assume that MNQ Firm is trying to undertake a brand new mission. The money flows and relevant low cost price are offered within the third tab of SU_MBA6010_Final_Project_Information.xls within the Doc Sharing space. Calculate the IRR, NPV, MIRR, and payback interval of the mission. The corporate has a three-year payback cutoff interval for tasks. Decide if it makes monetary sense for the corporate to undertake the mission. Justify your resolution. Submit your solutions in a 5- to 7-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week-Four Task-Three Primarily based on the info on the fourth tab of SU_MBA6010_Final_Project_Information.xls, offered within the Doc Sharing space, create an equally weighted portfolio of all ten shares (together with MNQ Firm and the opposite 9 shares) and estimate the beta of the portfolio. Utilizing the CAPM, decide the required price of return for the portfolio. Submit your solutions in a Three- to 5-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week 5 Task 2 • Find ten organizations that presently pay a typical inventory money dividend. Go to the Finance Net hyperlink offered within the Webliography, enter the ticker image of an S&P 500 firm within the quote field, and see whether or not it signifies that the corporate pays a dividend. • Calculate the organizations' price of fairness utilizing the dividend yield plus development price method and the safety market line (SML) mannequin method. • For every group, present how the price of fairness differs primarily based on the 2 approaches. Confer with the Net hyperlink Finance within the Webliography for info on beta of shares. Submit your solutions in a 2- to Three-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week 5 Task Three MNQ Firm's pretax price of debt is 7 %. Confer with the info on the first and second tabs of the spreadsheet SU_MBA6010_Final_Project_Information.xls offered within the Doc Sharing space. For this a part of the task solely, assume that MNQ Firm's guide worth capital construction weights equal its market worth capital construction weights. Estimate the corporate's price of capital for 2008. Submit your solutions in a Three- to 5-page Microsoft Phrase doc and your calculations in a Microsoft Excel sheet. Week 6 Task 2 Confer with the info on the primary and second tabs of SU_MBA6010_Final_Project_Information.xls offered within the Doc Sharing space. Assume that every one of MNQ Firm's gross sales are credit score gross sales. • Calculate and critique MNQ Firm's money conversion and working cycles from 2004 to 2008. • Create a 10- to 15-slide Microsoft PowerPoint presentation bringing collectively your findings from Weeks 1 by means of 6. Submit your solutions in a Three- to 5-page Microsoft Phrase doc, your calculations in a Microsoft Excel sheet, and your presentation in a Microsoft PowerPoint file.