Question one: (30 marks) Part one: Many accounting applications can be applied through Excel in business fields. Mention the benefits of using Excel in accounting department at financial firms and Banks with providing some examples for the main applications that can be applied. Part Two: provide a numerical example for using GROWTH function for prediction the expected number of units to be sold and the expected sales value in dollar based on actual number of unit sold.

Question Two: (15 marks) Explain in brief the mean and the usefulness for each of the following functions in accounting with provides an example for each one. 1. GEOMEAN function 2. PV function 1. TREND Function 2. FORECAST Function

Question Three: (20 marks) Income Statements for Xcel Energy from 2011 to 2013 appear below. Required: a. Enter the data into your worksheet. Assume that Cost of Revenue and Operation and Maintenance costs are variable. Depreciation and Other operating expenses are fixed costs. Ignore Other income when calculating EBT for the questions below. b. Given that Xcel Energy is a power company, would you expect that it would have more operating leverage or financial leverage? c. Calculate the degree of operating leverage for each year using the assumptions from part a. d. Calculate the degree of financial leverage for each year. e. Calculate the degree of combined leverage for each of the three years. Does it appear that Xcels leverage measures have been increasing or decreasing over this period? f. Create a line chart that shows how the various leverage measures have changed over this three-year period

Question Four: (15 marks) Amman Company on January1, 2016 purchased machine for 80000 JD with an estimated life 6 Years and estimated residual value of 8000 JD. Required 1. By using Excel create a new worksheet name Depreciation Expenses and entered the previous data on it, then insert necessary equations and functions in related cells to calculate depreciation expense, accumulated depreciation and carrying value of machine using three methods (straight- line, sum-of-the-Years- Digits and the Double Declining method) for the six years. 2. Represent the depreciation expense of the machine in the three different methods by graph (by chart). Question Five: (20 marks) Meyersons Bakery is considering the addition of a new line of pies to its product offerings. However, the following scenarios could be faced by this Bakery for the new line: First scenario: It is expected that each pie will sell for $17 and the variable costs per pie will be $11. Total fixed operating costs are expected to be $25,000. Meyersons faces a marginal tax rate of 25%, will have interest expense associated with this line of $3,500, and expects to sell about 4,500 pies in the first year. Second scenario: It is expected that each pie will sell for $15 and the variable costs per pie will be $9. Total fixed operating costs are expected to be $20,000. Meyersons faces a marginal tax rate of 35%, will have interest expense associated with this line of $3,000, and expects to sell about 4,000 pies in the first year. Required: a. Create an income statement for the pie lines first year for both scenarios. Is the line expected to be profitable under which scenarios? b. Calculate the operating break-even point in both units and dollars for each scenario. c. Under the first scenario, How many pies would Meyersons need to sell in order to achieve EBIT of $20,000? (EBIT = Earnings Before Interest and Taxes). d. Under the second scenario, How many pies would Meyersons need to sell in order to achieve EBIT of $15,000? (EBIT = Earnings Before Interest and Taxes). e. Use the Goal Seek tool to determine the selling price per pie that would allow Meyersons to break even in terms of its net income. Good Luck