Accounting > Solutions Guide > ACCT370 Excel Project Part 3 (All)

ACCT370 Excel Project Part 3

Document Content and Description Below

EXCEL PROJECT: PROJECTING FINANCIAL STATEMENTS ASSIGNMENT INSTRUCTIONS OVERVIEW Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balanc... e Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15), and Projected Financial Statements (Tabs 16-18) INSTRUCTIONS Continue in the same Excel workbook prepared in Module 4: Week 4, adding the following tabs: o The 12th tab in your Financial Statement Analysis Template must be labeled Common Sized Balance Sheets.  Set-up like the Historical Balance Sheets (Tab 3), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Balance Sheets for the calculations. “Total Assets” should be used as the base for all common sized calculations on the Balance Sheets. Common sized percentages should be calculated for all three historical years presented.  See Exhibit A for a partial example of this tab. o The 13th tab in your Financial Statement Analysis Template must be labeled Common Sized Income Statements.  Set-up like the Historical Income Statements (Tab 2), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Income Statements for the calculations. “Revenue” or “Total Revenue” (depending on your company) should be used as the base for all common sized calculations on the Income Statements. Common sized percentages should be calculated for all three historical years presented. o The 14th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance Sheets.  Start by copying and pasting the Historical Balance Sheets from Tab 3 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years.  See Exhibit B for an example of this tab. o The 15th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income Statements.  Start by copying and pasting the Historical Income Statements from Tab 2 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years. o The 16th tab in your Financial Statement Analysis Template must be labeled Projected Income Statements. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report. o The 17th tab in your Financial Statement Analysis Template must be labeled Projected Balance Sheets. Three years of projected statements should be included. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report. o The 18th tab in your Financial Statement Analysis Template must be labeled Projected Statement of Cash Flows. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report.  Other information relating to projected tabs:  Projections should be based on research performed on your company and its industry. Use historical, trend, ratio data and current and future economic projections as well as information from the company’s MD&A to aid in preparing projections.  Clearly state your assumptions in a text box at the bottom of each tab. Cite sources for assumptions based on research.  The statements should be consistent, reasonable, and accurate. Areas that will be checked for accuracy include: • The Balance Sheets should balance for all years presented. • Retained earnings should be properly calculated using the prior year’s balance, net income, and dividends. • The Ending Cash Balance on the Statement of Cash Flows should agree to the Cash Balance shown on the Balance Sheet for the same year. • Net Income on the Income Statements should match what is reported on the top of the Statement of Cash Flows (if indirect method is used). o Other instructions:  The Excel workbook should be professionally formatted. Professional formatting includes: • All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent. • Dollar signs are included in the first and last numbers of each column. • Subtotals and totals are preceded by a single underline. Totals are followed by a double underline. • Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read.  All common sized, horizontal analysis, and projection items should be calculated using formulas. Totals and subtotals should also be calculated using formulas. For an example of which cells may need formulas, please see Exhibits A & B. Note: Your assignment will be checked for originality via the Turnitin plagiarism tool. EXHIBIT A: EXAMPLE COMMON SIZED BALANCE SHEETS (TAB 12, PARTIAL VIEW) (IMPORTANT NOTE: ONLY PARTIAL BALANCE SHEET SHOWN. YOUR BALANCE SHEET SHOULD INCLUDE LIABILITIES AND STOCKHOLDERS’ EQUITY AS WELL.) EXHIBIT B: EXAMPLE HORIZONTAL ANALYSIS OF BALANCE SHEETS (TAB 14, PARTIAL VIEW) (IMPORTANT NOTE: ONLY PARTIAL BALANCE SHEET SHOWN. YOUR BALANCE SHEET SHOULD INCLUDE LIABILITIES AND STOCKHOLDERS’ EQUITY AS WELL.) [Show More]

Last updated: 10 months ago

Preview 1 out of 20 pages

Reviews( 0 )

Recommended For You

 Managerial Economics> Solutions Guide > Managerial Economics in a Global Economy 8th Edition By Dominick Salvatore (Solutions Manual ) (All)

preview
Managerial Economics in a Global Economy 8th Edition By Dominick Salvatore (Solutions Manual )

Reflecting the highly globalized nature of tastes, production, labor markets, and financial markets in today's world, Managerial Economics in a Global Economy, Eighth Edition, presents the theory of t...

By eBookSmTb , Uploaded: Jun 01, 2022

$20

 Business Administration> Solutions Guide > Australasian Business Statistics 4th Edition By Black, Asafu ,Adjaye, Burke, Khan, King, Perera, Papadimos, Sherwood, Wasimi (Solution Manual All Chapters) (All)

preview
Australasian Business Statistics 4th Edition By Black, Asafu ,Adjaye, Burke, Khan, King, Perera, Papadimos, Sherwood, Wasimi (Solution Manual All Chapters)

Data-driven decisions are driving the global knowledge economy. To get the edge, graduates need the power of statistical analysis to create business insight. This fourth edition of Australasian Busine...

By eBookSmTb , Uploaded: Nov 23, 2021

$20

 Business Law> Solutions Guide > International Economics Theory and Policy 12th edition By Paul R. Krugman, Maurice Obstfeld, Marc Melitz (Solutions Manual ) (All)

preview
International Economics Theory and Policy 12th edition By Paul R. Krugman, Maurice Obstfeld, Marc Melitz (Solutions Manual )

1. Introduction PART 1: INTERNATIONAL TRADE THEORY 2. Word Trade: An Overview 3. Labor Productivity and Comparative Advantage: The Ricardian Model 4. Specific Factors and Income Distribution 5....

By eBookSmTb , Uploaded: Nov 05, 2022

$25

 Education> Solutions Guide > Essentials of Accounting for Governmental and Not-for-Profit Organizations, 14th Edition By Paul Copley (Solutions Manual ) (All)

preview
Essentials of Accounting for Governmental and Not-for-Profit Organizations, 14th Edition By Paul Copley (Solutions Manual )

The focus of Copley's Essentials of Accounting for Governmental and Not-for-Profit Organizations, 14th edition is on the preparation of external financial statements which is a challenge for governmen...

By eBookSmTb , Uploaded: Oct 07, 2022

$20

 Urban Policy and Planning> Solutions Guide > Dental list Yellow pages (All)

preview
Dental list Yellow pages

HumanaDental PPO dental directory Location: 15 miles from 07304 May 16, 2018 Dentist Locations: 4638 Get the most out of your dental plan. the covered person must send us a letter requesting a...

By Academia1434 , Uploaded: Mar 30, 2021

$1

 Statistics> Solutions Guide > MAT 240 Module Five Assignment Hypothesis Testing for Regional Real Estate Company (All)

preview
MAT 240 Module Five Assignment Hypothesis Testing for Regional Real Estate Company

Scenario You have been hired by the Regional Real Estate Company to help them analyze real estate data. One of the company’s Pacific region salespeople just returned to the office with a newly desi...

By ACADEMICTUTORIAL , Uploaded: May 26, 2022

$4

 Finance> Solutions Guide > Week 4 Mini Case Complete The Chapter 9 (All)

preview
Week 4 Mini Case Complete The Chapter 9

During the last few years, Jana Industries has been too constrained by the high cost of capital to make many capital investments. Recently, though, capital costs have been declining, and the company h...

By ACADEMICTUTORIAL , Uploaded: May 26, 2022

$3.5

 Business> Solutions Guide > Read the Chapter 19 Mini Case in Financial Management: Theory and Practice (All)

preview
Read the Chapter 19 Mini Case in Financial Management: Theory and Practice

Chapter 18 leasing and financing Chapter 19 Mini Case in Financial Management Lewis Securities Inc Read the Chapter 19 Mini Case in Financial Management: Theory and Practice. Using complete sen...

By ACADEMICTUTORIAL , Uploaded: May 01, 2023

$5.5

 Calculus> Solutions Guide > Applied Calculus, 6th Edition By Hughes-Hallett, Lock, Gleason (Solutions Manual) (All)

preview
Applied Calculus, 6th Edition By Hughes-Hallett, Lock, Gleason (Solutions Manual)

A text for interactive Calculus courses, featuring innovative problems This sixth edition of Applied Calculus engages students with well-constructed problems and content to deepen understanding. The R...

By eBookSmTb , Uploaded: Dec 09, 2022

$25

 Engineering> Solutions Guide > Discovering AutoCAD 2020, 1st edition By Mark Dix, Paul Riley (Solutions Manual ) (All)

preview
Discovering AutoCAD 2020, 1st edition By Mark Dix, Paul Riley (Solutions Manual )

PART ONE: BASIC TWO-DIMENSIONAL ENTITIES Chapter 1 Lines and Essential Tools 1 Introduction 1 Creating a New Drawing 2 Exploring the Drawing Window 5 Interacting with the Drawin...

By eBookSmTb , Uploaded: Nov 16, 2022

$25

$6.50

Add to cart

Instant download

Can't find what you want? Try our AI powered Search

OR

GET ASSIGNMENT HELP
85
0

Document information


Connected school, study & course



About the document


Uploaded On

Feb 14, 2023

Number of pages

20

Written in

Seller


seller-icon
ACADEMICTUTORIAL

Member since 3 years

12 Documents Sold


Additional information

This document has been written for:

Uploaded

Feb 14, 2023

Downloads

 0

Views

 85

Document Keyword Tags

THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

custom preview

Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

custom preview

Get the best grades

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

custom preview

Earn from your notes

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

WHAT STUDENTS SAY ABOUT US


What is Browsegrades

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·