Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Provisional balance sheet excel format

20/11/2021 Client: muhammad11 Deadline: 2 Day

ACCT 370

Excel Project Part III Grading Rubric

(100 point Maximum)

Criteria

Levels of Achievement

Content/Accuracy

(70 points)

Advanced

Proficient

Developing

Not present

Content/Accuracy – Tab 12 – Common Sized Balance Sheets

(7 points)

7 points

Student included three years of common sized balance sheets. Balance sheets were based on the historical balance sheets, taken from the 10-K reports. All common sized calculations were performed accurately, using total assets as the base.

5 to 6 points

Student included three years of common sized balance sheets. Balance sheets were based on the historical balance sheets, taken from the 10-K reports. All common sized calculations were performed accurately, using total assets as the base, with only minor exceptions.

1 to 4 points

Common sized balance sheets were not calculated accurately, or did not include three years of balance sheets based on the 10-K reports, as required.

0 points

Not present

Content/Accuracy – Tab 13 – Common Sized Income Statements

(7 points)

7 points

Student included three years of common sized income statements. Income Statements were based on the historical income statements, taken from the 10-K reports. All common sized calculations were performed accurately, using sales, revenue, or total revenue as the base.

5 to 6 points

Student included three years of common sized income statements. Income Statements were based on the historical balance sheets, taken from the 10-K reports. All common sized calculations were performed accurately, using sales, revenue, or total revenue as the base, with only minor exceptions.

1 to 4 points

Common sized income statements were not calculated accurately, or did not include three years of income statements based on the 10-K reports, as required.

0 points

Not present

Content/Accuracy – Tab 14 – Horizontal Analysis Balance Sheets

(7 points)

7 points

Student included three years of balance sheets, based on the historical balance sheets taken from the 10-K reports. All horizontal analysis ($ and % change) calculations were performed accurately.

5 to 6 points

Student included three years of balance sheets, based on the historical balance sheets taken from the 10-K reports. All horizontal analysis ($ and % change) calculations were performed accurately, with only minor exceptions.

1 to 4 points

Horizontal analysis balance sheets were not calculated accurately, or did not include three years of balance sheets based on the 10-K reports, as required.

0 points

Not present

Content/Accuracy – Tab 15 – Horizontal Analysis Income Statements

(7 points)

7 points

Student included three years of income statements, based on the historical income statements taken from the 10-K reports. All horizontal analysis ($ and % change) calculations were performed accurately.

5 to 6 points

Student included three years of income statements, based on the historical income statements taken from the 10-K reports. All horizontal analysis ($ and % change) calculations were performed accurately, with only minor exceptions.

1 to 4 points

Horizontal analysis income statements were not calculated accurately, or did not include three years of income statements based on the 10-K reports, as required.

0 points

Not present

Content/Accuracy – Tab 16 – Projected Income Statements (14 points)

13 to 14 points

Student included three years of projected income statements, supported by written assumptions that were developed with the company’s historical 10-K and research. The income statement numbers were reasonable, given the company’s historical trends and the written assumptions provided.

10 to 12 points

Student included three years of projected income statements, supported by written assumptions that were developed with the company’s historical 10-K and research, with only minor exceptions. The income statement numbers were mostly reasonable, given the company’s historical trends and the written assumptions provided, with only minor exceptions.

1 to 9 points

The student neglected to include a full three years of projected income statements, and/or the projections were not supported by appropriate written assumptions. If written assumptions were provided, they may be lacking in support from research. Projected income statement may lack reasonableness, given the company’s historical trends.

0 points

Not present

Content/Accuracy – Tab 17 – Projected Balance Sheets (14 points)

13 to 14 points

Student included three years of projected balance sheets, supported by written assumptions that were developed with the company’s historical 10-K and research. The balance sheet balanced, and the numbers presented were reasonable, given the company’s historical trends and the written assumptions provided. Retained earnings were appropriately calculated.

10 to 12 points

Student included three years of projected balance sheets, supported by written assumptions that were developed with the company’s historical 10-K and research, with only minor exceptions. The balance sheet balanced, and the numbers presented were mostly reasonable, given the company’s historical trends and the written assumptions provided, with minor exceptions. Retained earnings were appropriately calculated, with minor exceptions.

1 to 9 points

The student neglected to include a full three years of projected balance sheets, and/or the projections were not supported by appropriate written assumptions. If written assumptions were provided, they may be lacking in support from research. Projected balance sheets did not balance and/or retained earnings were not appropriate calculated.

0 points

Not present

Content/Accuracy – Tab 18 – Projected Cash Flows (14 points)

13 to 14 points

Student included three years of projected cash flows, supported by written assumptions that were developed with the company’s historical 10-K and research. The cash flows statement was reasonable, given the numbers presented on the projected income statements and balance sheets, and given the company’s historical trends and written assumptions provided. The three sections of the cash flows statement added up to the net change in cash, based on the projected balance sheets.

10 to 12 points

Student included three years of projected cash flows, supported by written assumptions that were developed with the company’s historical 10-K and research. Minor issues were identified with the reasonableness of the statement, and its consistency with the projected balance sheets and income statements. The three sections of the cash flows statement added up to the net change in cash, based on the projected balance sheets, with only minor exceptions.

1 to 9 points

The student neglected to include a full three years of projected cash flows, and/or the projections were not supported by appropriate written assumptions. If written assumptions were provided, they may be lacking in support from research. The three sections of the cash flows statement did not add up to the net change in cash calculated, and/or did not agree with the cash balances on the balance sheets.

0 points

Not present

Excel Formulas, Style, and Formatting

(30 points)

Advanced

Proficient

Developing

Not present

Excel Functions/Formulas

(15 points)

14 to 15 points

Excel formulas are utilized to calculate all common size and horizontal analysis figures, as well as line items from the projected financial statements. Formulas in the projected financial statements reflected the assumptions provided by the student. Totals and subtotals in the projected financial statements are appropriate calculated with Excel formulas.

11 to 13 points

Only minor issues with the required use of Excel formulas were identified. Excel formulas are utilized to calculate all common size and horizontal analysis figures, as well as line items from the projected financial statements. Formulas in the projected financial statements reflected the assumptions provided by the student. Totals and subtotals in the projected financial statements are appropriate calculated with Excel formulas.

1to 10 points

Many of the Excel formulas required to calculate common size, horizontal analysis, and projected financial statements were missing or incomplete. Excel formulas were not used consistently in required areas.

0 points

Not present

Style and Formatting

(15 points)

14 to 15 points

The submission is professionally formatted. All tabs include appropriate headings with the required information. Totals and subtotals in the common size, horizontal analysis, and projected financial statements are identified with properly placed underlines. Numbers are formatted consistently, including the use of commas and decimals. The submission is consistent, neat, and easy to read.

11 to 13 points

The submission is professionally formatted, with only minor exceptions to the following: All tabs include appropriate headings with the required information. Totals and subtotals in the common size, horizontal analysis, and projected financial statements are identified with properly placed underlines. Numbers are formatted consistently, including the use of commas and decimals. The submission is consistent, neat, and easy to read.

1 to 10 points

The submission lacks in professional formatting. It is missing headings, appropriately placed underlines, and/or consistent formatting. The submission is messy, hard to read, or substantially inconsistent in formatting.

0 points

Not present

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

24/7 Assignment Help
Accounting & Finance Master
Financial Assignments
Quick Finance Master
Buy Coursework Help
Online Assignment Help
Writer Writer Name Offer Chat
24/7 Assignment Help

ONLINE

24/7 Assignment Help

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$18 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$48 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$16 Chat With Writer
Quick Finance Master

ONLINE

Quick Finance Master

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$24 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$27 Chat With Writer
Online Assignment Help

ONLINE

Online Assignment Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Week 03: Functions of the Fed - Necessities - Paper on COSO framework - Cipd level 3 assignment answers - Distance between hawaii and maui in cm - Ikea ps 2014 corner easy chair with cushions - Hey hey diddly bop bop cadence - Placatingly in a sentence - A workbook for aphasia - Brave new world feelies chapter - Misplacing the burden of proof - Paper Due Sunday - Leadership in Healthcare Organization DW4 - Moloch owl god california - Words their way poems - Avon global strategy - Essay - Life Cycle Assessment - Vcalcium floodlights civil war - A self contained breathing apparatus uses potassium superoxide - Arnold palmer hospital case study answers - Aggregate is a form of plagiarism that happens when - Ethical dilemmas in education scenarios - 202 stanhill drive chevron island - Why is pressure a scalar - Hospital fire safety manual - His 100 multimedia presentation planning worksheet - Understanding and managing diversity 6th edition pdf - Security controls - Nuisance tripping of rccb - Cisco labsim - AVP - Playhouse child development center dewitt mi - Eco 561 week 2 knowledge check - Discussion Week 7 - Greek hero killed by a giant scorpion crossword - In a harris interactive survey 2303 adults - Similarities between samurai and knights - Literary and cultural theory from basic principles to advanced applications - World and screen nicholas carr summary - Mercantile credit co v garrod - Driven damped harmonic oscillator - You swim when you were 10 - Speech topic - Lens equation practice problems - Sandalwood nuts for sale - Contour belt replacement gel pads - Pat maths 4th edition test 4 - Cytokines immunology 500 words due 8/11/2020 at 11 pm eastern US. - Bs5308 instrument cable specification - Their eyes were watching god narrator - Elements of job analysis in hrm - Queensland number plate search - HRM530 Assignment - Changing the subject of a formula - Dinitrogen pentoxide water hydrogen nitrate - Problem Statement/ Research Questions - St martin guide to writing 8th edition pdf - The most consistent feature of workplace drug prevention programs has been - Design project report example - A beam of protons traveling at - Global marketing svend hollensen 6th edition - Bicameral structure of parliament australia - Hilton's transformation case study - Jana wendt eye disease - Hacking into harvard case 2.1 answers - Mde manufacturing budget bird feeder - What did snidely say after filling - Ilearn health qld gov au - Afi strategy framework - Advanced Calculus - Diary of a madman summary sparknotes - Mountain dew harvard case study - Answer 3 objectives questions - A case structure is the only decision structure that can be used in a menu-driven program. - Case Study 2: National Collegiate Athletic Association Ethics and Compliance Program - Escience lab kit redemption card - Pool cpr sign nsw - Pro rata allotment of shares calculation - Axe target market demographics - Somewhere i have never travelled poem analysis pdf - Https test script recorder jmeter - If a student randomly guesses at 20 multiple-choice questions - Iliad book 6 greek - Friedland libra+ additional portable chime d917 - Average reaction time ruler drop test - A toddler in stage five of sensorimotor development is a “little scientist.” - Gestalt and person centered therapy debate - Social psychology 10th edition pdf aronson - Legal environment of business 3rd edition melvin - Usd to sgd spot rate - Royal shrewsbury hospital consultants - Management - Cavendish estate agents mold - Snoopy's dog breed crossword - Physics Help Needed!!! NOW - English housing survey data - Discussion - Taxation (120 words) - Namo tassa bhagavato arahato samma sambuddhassa mp3 song