(This is part 3 of the project) <\/p>\n
EXCEL PROJECT: PROJECTING FINANCIAL STATEMENTS ASSIGNMENT
\nINSTRUCTIONS
\nOVERVIEW
\nCommon Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13),
\nHorizontal Analysis Balance Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15),
\nand Projected Financial Statements (Tabs 16-18)
\nINSTRUCTIONS<\/p>\n
\nContinue in the same Excel workbook prepared in Module 4: Week 4, adding the following
\ntabs:
\no The 12th tab in your Financial Statement Analysis Template must be labeled
\nCommon Sized Balance Sheets.
\n\uf0a7 Set-up like the Historical Balance Sheets (Tab 3), this worksheet should use
\nformulas to calculate the common sized percentages, linking to the Historical
\nBalance Sheets for the calculations. \u201cTotal Assets\u201d should be used as the base
\nfor all common sized calculations on the Balance Sheets. Common sized
\npercentages should be calculated for all three historical years presented.
\n\uf0a7 See Exhibit A for a partial example of this tab.
\no The 13th tab in your Financial Statement Analysis Template must be labeled
\nCommon Sized Income Statements.
\n\uf0a7 Set-up like the Historical Income Statements (Tab 2), this worksheet should use
\nformulas to calculate the common sized percentages, linking to the Historical
\nIncome Statements for the calculations. \u201cRevenue\u201d or \u201cTotal Revenue\u201d
\n(depending on your company) should be used as the base for all common sized
\ncalculations on the Income Statements. Common sized percentages should be
\ncalculated for all three historical years presented.
\no The 14th tab in your Financial Statement Analysis Template must be labeled
\nHorizontal Analysis of Balance Sheets.
\n\uf0a7 Start by copying and pasting the Historical Balance Sheets from Tab 3 to this
\nworksheet. Then, add dollar and percentage change columns between each of
\nthe set of historical years.
\n\uf0a7 See Exhibit B for an example of this tab.
\no The 15th tab in your Financial Statement Analysis Template must be labeled
\nHorizontal Analysis of Income Statements.
\n\uf0a7 Start by copying and pasting the Historical Income Statements from Tab 2 to
\nthis worksheet. Then, add dollar and percentage change columns between each
\nof the set of historical years.
\no The 16th tab in your Financial Statement Analysis Template must be labeled
\nProjected Income Statements. Three years of projected statements should be
\nincluded, starting with the most recent year after the company\u2019s last issued report.
\no The 17th tab in your Financial Statement Analysis Template must be labeled
\nProjected Balance Sheets. Three years of projected statements should be <\/p>\n
ACCT 370
\nPage 2 of 4
\nincluded. Three years of projected statements should be included, starting with
\nthe most recent year after the company\u2019s last issued report.
\no The 18th tab in your Financial Statement Analysis Template must be labeled
\nProjected Statement of Cash Flows. Three years of projected statements should
\nbe included, starting with the most recent year after the company\u2019s last issued
\nreport.
\n\uf0a7 Other information relating to projected tabs:
\n\uf0a7 Projections should be based on research performed on your company
\nand its industry. Use historical, trend, ratio data and current and future
\neconomic projections as well as information from the company\u2019s
\nMD&A to aid in preparing projections.
\n\uf0a7 Clearly state your assumptions in a text box at the bottom of each tab.
\nCite sources for assumptions based on research.
\n\uf0a7 The statements should be consistent, reasonable, and accurate. Areas
\nthat will be checked for accuracy include:
\n\uf0b7 The Balance Sheets should balance for all years presented.
\n\uf0b7 Retained earnings should be properly calculated using the prior
\nyear\u2019s balance, net income, and dividends.
\n\uf0b7 The Ending Cash Balance on the Statement of Cash Flows
\nshould agree to the Cash Balance shown on the Balance Sheet
\nfor the same year.
\n\uf0b7 Net Income on the Income Statements should match what is
\nreported on the top of the Statement of Cash Flows (if indirect
\nmethod is used).
\no Other instructions:
\n\uf0a7 The Excel workbook should be professionally formatted. Professional
\nformatting includes:
\n\uf0b7 All numbers are formatted similarly. The use of decimals, commas
\nfor thousands, and other formatting is consistent.
\n\uf0b7 Dollar signs are included in the first and last numbers of each
\ncolumn.
\n\uf0b7 Subtotals and totals are preceded by a single underline. Totals are
\nfollowed by a double underline.
\n\uf0b7 Line descriptions are indented\/bolded in a manner that makes the
\nspreadsheet easy to read.
\n\uf0a7 All common sized, horizontal analysis, and projection items should be
\ncalculated using formulas. Totals and subtotals should also be calculated
\nusing formulas. For an example of which cells may need formulas, please
\nsee Exhibits A & B.
\nNote: Your assignment will be checked for originality via the Turnitin plagiarism tool.ACCT 370
\nPage 2 of 4
\nincluded. Three years of projected statements should be included, starting with
\nthe most recent year after the company\u2019s last issued report.
\no The 18th tab in your Financial Statement Analysis Template must be labeled
\nProjected Statement of Cash Flows. Three years of projected statements should
\nbe included, starting with the most recent year after the company\u2019s last issued
\nreport.
\n\uf0a7 Other information relating to projected tabs:
\n\uf0a7 Projections should be based on research performed on your company
\nand its industry. Use historical, trend, ratio data and current and future
\neconomic projections as well as information from the company\u2019s
\nMD&A to aid in preparing projections.
\n\uf0a7 Clearly state your assumptions in a text box at the bottom of each tab.
\nCite sources for assumptions based on research.
\n\uf0a7 The statements should be consistent, reasonable, and accurate. Areas
\nthat will be checked for accuracy include:
\n\uf0b7 The Balance Sheets should balance for all years presented.
\n\uf0b7 Retained earnings should be properly calculated using the prior
\nyear\u2019s balance, net income, and dividends.
\n\uf0b7 The Ending Cash Balance on the Statement of Cash Flows
\nshould agree to the Cash Balance shown on the Balance Sheet
\nfor the same year.
\n\uf0b7 Net Income on the Income Statements should match what is
\nreported on the top of the Statement of Cash Flows (if the indirect
\nmethod is used).
\no Other instructions:
\n\uf0a7 The Excel workbook should be professionally formatted. Professional
\nformatting includes:
\n\uf0b7 All numbers are formatted similarly. The use of decimals, commas
\nfor thousands, and other formatting are consistent.
\n\uf0b7 Dollar signs are included in the first and last numbers of each
\ncolumn.
\n\uf0b7 Subtotals and totals are preceded by a single underline. Totals are
\nfollowed by a double underline.
\n\uf0b7 Line descriptions are indented\/bolded in a manner that makes the
\nspreadsheet easy to read.
\n\uf0a7 All common-sized, horizontal analysis and projection items should be
\ncalculated using formulas. Totals and subtotals should also be calculated
\nusing formulas. For an example of which cells may need formulas, please
\nsee Exhibits A & B.
\nNote: Your assignment will be checked for originality via the Turnitin p<\/p>\n","protected":false},"excerpt":{"rendered":"
(This is part 3 of the project) EXCEL PROJECT: PROJECTING FINANCIAL STATEMENTS ASSIGNMENT INSTRUCTIONS OVERVIEW Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balance 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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[183],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/4319"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=4319"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/4319\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=4319"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=4319"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=4319"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=4319"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}