Excel Question

Part 1: Financial Statements

Open the Excel file EA2-E2_FinancialStatements found in the Excel – Weeks 1-5 Folder in the Student Files zip file. Note that this is a blank template.

From Microsoft Excel for Accounting, complete “Extend Your Skills EA2-E2: Create Financial Statements for BeBo Industries” found in Chapter 2 of your Microsoft Excel for Accounting text.

Use formulas and functions to create the following financial statements for the firm on separate tabs in the template, using the same names provided here:

Prepare the firm’s Balance Sheet with 0-2 errors or omissions, including the use of Excel formulas for required calculations.

Prepare the firm’s Income Statement with 0-2 errors or omissions, including the use of Excel formulas for required calculations.

Prepare the firm’s Statement of Owner’s Equity with 0-2 errors or omissions, including the use of Excel formulas for required calculations.

Part 2: Computing Financial Ratios

Refer to Chapter 9 of Microsoft Excel for Accounting to access formulas for these ratio calculations.

Using the data from the financial statements in Part 1, perform the specified ratio analyses with 0-2 errors or omissions that include the use of Excel formulas.

Current ratio.

Quick ratio.

Debt ratio.

Equity ratio.

Debt-to-equity ratio.

Profit margin ratio.

Requirements

Note: You must use Excel formulas to compute the ratios and totals on the financial statements where applicable. Points will be deducted if you do not use formulas for calculations.

Submit one Excel file with the following tabs:

Balance Sheet.

Income Statement.

Statement of Owner’s Equity.

Financial Ratios.

The specific course learning outcome associated with this assignment is:

Demonstrate the use of various functions and applications in Microsoft Excgjvel for accounting records and reports.

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER