Financial Statement Analysis Question1 Mr Raj joined the company named Kamat Ltd as an accounts executive. On the very first day, his senior gave him the task of designing the Common-Size Statements with adequately structuring its types for the financial statements. Discuss about common size statement and its types. Also, how Comparative statements and common…
Read DetailsFinancial Modeling 1. Using Google Spreadsheet, create a dynamic model for computing beta for any NSE listed Stock. Use monthly historical data of 5 years for beta computation. Use the computed beta to apply CAPM Model and compute required/expected rate of return for an investor. 10 Year govt. bond yield should be used for risk…
Read DetailsFinancial Management Q1. From the below-given data calculate the overall cost of capital (WACC) for Business Scanner Ltd. (10 Marks) Equity Capital 20,00,000 11% Debt 30,00,000 Tax Rate 30% The risk-free rate of return 6% Sensex yearly return 15% Beta 1.4 Introduction Common shares, preferred shares, securities, and various other types…
Read DetailsFinancial Management Q1. From the below-given data calculate the overall cost of capital (WACC) for Business Scanner Ltd. (10 Marks) Equity Capital 20,00,000 11% Debt 30,00,000 Tax Rate 30% The risk-free rate of return 6% Sensex yearly return 15% Beta 1.4 Introduction Common shares, preferred shares, securities, and various other types…
Read DetailsFinancial Institutions & Markets Q1. “Financial institutions are an important component of a financial system. They specialise in financial and monetary activities at the both retail and commercial segment.” These financial institutions manage the capital flows in the financial market. Explain the various categories of financial institutions with examples according to the activities they undertake…
Read DetailsEssentials of IT 1) Use the table presented below to answer the following questions: Highlight all the dates after October 10, 2018 (1 mark) Highlight all the grades above average in English (1 mark) Highlight all the duplicate names (1 mark) Highlight all cells greater than the median of the range in English. (2…
Read DetailsEnvironment & Disaster Management 1) India’s Meteorological Department (IMD), observes a cyclonic disturbance pattern, which spells of an impending likelihood of a cyclone which is likely to impact coastal regions of Odisha & Andhra Pradesh. You are in charge of NDRF (National Disaster Response Force). Suggest various modern disaster management steps to help the entire…
Read DetailsEmerging Trends in Accountancy 1. You are required to EXPLAIN the need for accounting information for the organisation, different users of accounting information and qualitative attributes that must be present in such accounting information. Introduction Accounting is the process of documenting, summarizing, analyzing, and providing interpretations of a business organization’s financial data. Accounting information…
Read DetailsData Visualization with Tableau Question 1: Consider you are working as a business analyst with Elizabeth Hospitals, a UK-based hospital chain across different cities in the United Kingdom. You have been tasked with building presentations for executive management using critical business data. Explain the different geographic charts you can make across various departments. Mention how…
Read DetailsCustomer Relationship Management Q.1. You are working as a manager in a sports goods company. The company so far was happy conducting business the traditional way and was following traditional customer relationship management. However, your CEO wants to embrace the digital wave. He requires your help to enumerate the goals of e-CRM and how would…
Read Details