Is Ramirez suggestion on the excel function

Assignment Help Financial Accounting
Reference no: EM132909242

Question - The Bank of MF is a California-based equity investment consulting company. The company primarily provides advises to both institutional and individual investors. The company is specialized in fundamental analysis that involves collecting and evaluating the accounting statements of publicly traded companies.

Sonia Ramirez is a sophomore at the University of MF. She is preparing for an interview for a co-op opportunity at the Bank of MF. The Bank of MF informed her that she will need to take a quiz that evaluates her ability to use Microsoft Excel during the interview.

To prepare for the quiz, Ramirez collects the following data and presents them in an Excel spreadsheet. The number of shares outstanding had always been 200 shares from 2015 to 2019. Ramirez wants to calculate the company's current EPS from 2015 to 2019 and display the data in cell B9, C9, D9, E9, and F9, respectively. She also wants to use the appropriate Excel function to "lock" the value of the number of shares outstanding shown in cell B7 so that she could drag the excel function in cell B9 and drop it to cell C9, D9, E9, and F9. Therefore, Ramirez suggests the function she should use to calculate 2015's current EPS in cell B9 should be =B3/B$7.

Is Ramirez's suggestion on the excel function used to calculate 2015's current EPS justifiable? Why?

Reference no: EM132909242

Questions Cloud

Explain the various lines of communication and reporting : Explain the various lines of communication and reporting. Identify what you have observed to be the formal and informal reporting lines
Discuss the historical application of statistics in field : Discuss the historical application of statistics in the field of health care. Describe an example, other than Florence Nightingale's contributions
Keys to success : With the understanding that the CIO and the IT organization are the threads that connect the entire organization,
How statistical data is used in organization area today : How statistical data is used in your organization or specialty area today and what you are expected to do with this information as a practitioner.
Is Ramirez suggestion on the excel function : The Bank of MF is a California-based equity investment consulting company. Is Ramirez suggestion on the excel function
Contrast religious beliefs and health practices : Compare and contrast your religious beliefs and health practices with the beliefs and health practices of someone with a different religion.
Organization prior to any development or enhancements : Write a project introduction that documents the current state of the organization prior to any development or enhancements,
What will be real effect on profit if the order is accepted : The $56 of fixed overhead is allocated as $1.10 per direct labor dollar. What will be real effect on profit if the order is accepted
Why is the importance of apa when writing : Why is the importance of APA when writing? How does APA help you become a better writer? Use module APA for guidance to answer this prompt

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd