Assignment 1
Develop a comprehensive understanding the field of financial management and recent developments in the field.
Q1. Discuss the recent trends and developments in the field of finance.
Assignment 2
Explore the role of financial management in promoting sustainable business practices and development.
Download the attached article and answer the following questions.
Q1. What are the main components of sustainability?
Q2. What are the main objectives of the research paper?
Q3. Why Islamic banks have lower sustainability disclosures comparing with conventional banks?
2. Analyze the financial statements by applying data analytics and evaluate the financial performance of a company. (Q1)- Overall grade.
Assignment 3
Q1. Download the annual balance sheet and income statement of Apple Company (aapl) from Google Finance website, open an Excel sheet, and paste the balance sheet in "sheet1" and the income statement on "sheet2", Use Excel formulas to compute the following:
-Common size income statement
-Common base year income statement
-Combined Common size and common base year income statement
-Common size Balance Sheet
-Common base year Balance Sheet
-Combined Common size and common base year Balance Sheet
Assignment 4
Use spreadsheet software to analyze financial data and compute return and risk measures of financial securities in a complex environment.
Q1. Download the historical daily closing price of Apple Company (aapl) from Google Finance website for the period 1/1/2010-31/12/2014, download the data to excel, Use Excel formulas to compute the following:
-Holding period return
-Average holding period return
-Variance
Assignment 5
Q1 Compute the following ratios using the statements of Coca Cola for the year 2013 and 2012. Comment on the results and use the year 2012 as a benchmark for the year 2013.
|
2013 |
2012 |
|
| Current Ratio |
|
|
Current Ratio = Current Assets ÷Current Liabilities |
| Quick Ratio |
|
|
Quick Ratio = (Current Assets- Inventory) ÷Current Liabilities |
| Inventory turnover |
|
|
Inventory turnover = Cost of goods sold ÷ Inventory |
| Average Age of Inventory |
|
|
Average Age of Inventory = (Inventory ÷ CGS) *365 |
| Average Collection Period |
|
|
Average Collection Period = (Receivables ÷ Sales) *365 |
| Average Payments Period |
|
|
Average Payments Period = (Payables ÷ CGS) *365 |
| Total Asset Turnover |
|
|
Total asset turnover = Sales ÷ Total assets |
| Debt ratio |
|
|
Debt ratio = Total liabilities ÷ Total assets |
| Times interest earned ratio |
|
|
Times interest earned ratio = EBIT ÷ Interest |
| Gross Profit Margin |
|
|
Gross Profit Margin = (Sales - CGS) ÷ Sales |
| Operating profit margin |
|
|
Operating profit margin = (Sales - CGS - Depreciation) ÷ sales |
| Profit Margin |
|
|
Profit Margin = Net Income÷ Sales |
| Return on Assets (ROA) |
|
|
Return on Assets (ROA) = Net Income ÷ Total assets |
| Return on Equity (ROE) |
|
|
Return on Equity (ROE) = Net Income ÷ Total Equity |
• Comments on the above results:
Q2. Discuss the pros and cons of using perpetuity in real estate valuations?