This guide is for ACCT 209 Week 6 Excel Project, start to submission. From a fact situation, prepare financial statements and pro forma financial statements in Excel.
ACCT 209 is Survey of Accounting and Finance, 3 credit hours, in Liberty University's BS in Accounting. Canvas and the course guide file print the code as ACCT209; it is the same course.
| Course | ACCT 209 Survey of Accounting and Finance |
|---|---|
| Module/Week | 6 |
| Points | 150 points |
| Length | Excel workbook with the required statements |
| Sources | The fact situation provided and the textbook |
| Faith integration | Not required by the guide |
| Format | Microsoft Excel |
What ACCT 209 Week 6 Excel Project asks for
Given a fact situation, you prepare financial and pro forma financial statements using Excel. It is due in Module/Week 6 with Hicks chapter 6. Worth 150 points, tied for the largest assignment in the course.
Where it fits in ACCT 209
In the published schedule, Excel Project is one of 4 graded written assignments in ACCT 209. It follows Week 5 Discussion Board Forum 2 and comes before Week 7 Faith Essay.
How ACCT 209 Week 6 Excel Project is graded
Liberty grades Excel Project with the rubric attached to the assignment in Canvas, worth 150 points in the published guide. That is about 15% of the course's 1,010 points. The rubric rows are the real instructions. Draft against them, and you will rarely be surprised by the grade.
Course grades in ACCT 209 use Liberty's point scale: an A is 900 to 1010 points of the course total. Missing the length or source minimum usually costs points on several rows at once, which is why the checklist below starts with them.
Timing in the published guide: Each course module/week begins on Tuesday morning at 12:00 a.m. (ET) and ends on Monday night at 11:59 p.m. (ET). The final module/week ends at 11:59 p.m. (ET) on Friday. Check the due dates in your Canvas section, which govern.
The ACCT 209 Week 6 method, step by step
Set up the data before the write-up
Do the calculations first and check them. Interpretation built on a wrong figure loses more points than a missing paragraph.
Show the method
Name the method and the reason it fits. One or two sentences are enough, but they must be there.
Report the results plainly
Give the key figures in a labeled table and mention each in the text.
Interpret in the context of the question
Explain what the results mean for the decision or question in ACCT 209, in plain terms. The interpretation is where the analysis points are earned.
Name the limits
Name the assumptions and limits. A result with its limits stated reads as professional.
Submit the files the guide asks for
Check which files Canvas expects (spreadsheet, output, written document) and that each is complete and labeled (Excel workbook with the required statements).
A structure for ACCT 209 Week 6 Excel Project
Word targets are planning numbers for about 1,100 words of body text, set by the length in the guide; the rubric decides where to spend more.
| Section | What it must do | Target |
|---|---|---|
| Assumptions tab | The facts and growth assumptions in one place. | ~200 words |
| Income statement | Revenue, expenses and net income. | ~260 words |
| Balance sheet | Assets, liabilities and equity that balance. | ~260 words |
| Pro forma statements | Next period's projected statements. | ~240 words |
| Checks | Balance check and formulas visible. | ~130 words |
A topic angle that works
Put every given fact and assumption on one tab and reference those cells everywhere else. A pro forma statement built from formulas updates correctly when an assumption changes, and graders can follow it.
Model paragraph with notes
An original paragraph written by our desk to show the register that earns full rubric credit. It is study material: learn the moves, then write your own.
The pro forma income statement projects next year's sales at 8% above this year's $1.2 million, as the fact situation states, giving $1,296,000. Cost of goods sold stays at 60% of sales, so it is calculated as =B5*0.60 rather than typed in.1 On the pro forma balance sheet, retained earnings equal last year's balance plus projected net income less planned dividends, which ties the two statements together and makes the balance sheet balance.2
- Uses the given growth rate.
- Formulas, not typed numbers.
- Links the statements.
Mistakes that cost points on ACCT 209 Week 6
- Typed numbers instead of formulas.
- A balance sheet that does not balance.
- Ignoring the fact situation's assumptions.
Checklist before you submit
- Length: Excel workbook with the required statements
- Sources: The fact situation provided and the textbook
- Calculations checked and output saved
- Every table and figure referred to in the text
- Each rubric row read against the section that answers it
Questions students ask
What does pro forma mean in ACCT 209?
Projected financial statements for a future period, built from assumptions about sales, costs and other items.
How many points is ACCT 209 Week 6 Excel Project worth?
150 points in Liberty's published course guide for ACCT 209, out of a course total of 1,010 points (about 15% of the grade). The rubric attached to the assignment in Canvas shows how those points are divided.
Is ACCT 209 Week 6 the same in every section of ACCT 209?
This guide follows Liberty's published course guide for ACCT 209. Liberty notes that course content can change from term to term, so if your Canvas section shows different instructions, a different week or different points, follow Canvas and your instructor.
Want a tutor to look at your draft?
Send the instructions and what you have so far. A Liberty tutor replies with what to fix first, usually within the hour.