1 / 2

Project

business finance project here

Rabia40
Download Presentation

Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Department of Management Sciences CUI Islamabad Group Project of Business Finance (Fall 2024) Date: 19th November 2024 Download the most recent last two years Annual reports of your assigned companies. Requirements: Copy / transform the statement of financial position and Profit and loss statements of last three years in MS Excel (Sheet 1) Perform the following tasks using Excel formulas in your Excel file A.Ratios and their charts of last three years (Sheet 2). [10%] a.Liquidity Ratios: Current Ratio Acid Test Ratio b.Financial Leverage / Debt Ratios Total Debt to Equity Total Debt to Total Asset Long term debt to total Ratio Ratio capital Ratio c. Coverage Ratio: Times Interest earned / Interest coverage Ratio. d.Activity Ratio Receivable turn over. Average Collection period Payable Turnover PTO in days Inventory Turnover ITO in days Cash Cycle & Operating Cycle Total Asset Turnover e.Profitability Ratio GP Margin NP margin Return on Return on Equity Investment (ROI) (ROE) B.Vertical / Common size analysis for the past three years (Sheet 3). C.Horizontal / Index Analysis for the past three years (Sheet 3). 2. Submit the interpretation of your analysis in a MS Word file in report form. [10%] Report Contents Title Page Table of Contents List of Tables List of Figures 1 | 2

  2. Department of Management Sciences CUI Islamabad Chapter 1: Introduction (of the company name) Chapter 2: Trend Analysis (of the company name) Chapter 3: Common Size analysis for recent three years Chapter 4: Index analysis for the recent three years Chapter 5: Conclusion. References Chapter 2 Trend Analysis [Contents/headings] 2.1 Introduction 2.2 Current Ratio Table from Excel Chart from Excel Interpretation . . . 2.20 Return on Equity (ROE) Table from Excel Chart from Excel Interpretation 2.21 Chapter Discussion and conclusion Chapter 3 and 4 Contents/headings: Table from Excel Discussion and conclusion Instructions: •Report format must be consistent. •APA style Referencing style. •Report word count: 3,000 words from chapter 1 to chapter 5. •Plagiarism: Not more than 20% •Any use of generative AI tools in the project will lead to ZERO marks. 3. Viva [80%] Final report (Word /PDF file) and Excel file Submission Date (Soft copy): 20th December 2024. Email: ather.yaqub@comsats.edu.pk Late submissions will not be accepted under any circumstance. VIVA and Final Report Hard Copy Submission: 23rd December 2024. 2 | 2

More Related