This guide is for ACCT 370 Week 7 Excel Project Part 4, start to submission. Projected financial statements for your company, in Excel.
ACCT 370 is Financial Statement Analysis, 3 credit hours, in Liberty University's BS in Accounting. Canvas and the course guide file print the code as ACCT370; it is the same course.
| Course | ACCT 370 Financial Statement Analysis |
|---|---|
| Module/Week | 7 |
| Points | 50 points |
| Length | Excel workbook (Part 4) |
| Sources | The historical statements and your assumptions |
| Faith integration | Not required by the guide |
| Format | Microsoft Excel |
What ACCT 370 Week 7 Excel Project Part 4 asks for
Part 4 is projected financial statements for the company. It is due in Module/Week 7 with Revsine et al. chapters 14 and 15. Worth 50 points.
Where it fits in ACCT 370
In the published schedule, Excel Project Part 4 is one of 6 graded written assignments in ACCT 370. It follows Week 5 Excel Project Part 3 and comes before Week 8 Financial Analysis Report.
How ACCT 370 Week 7 Excel Project Part 4 is graded
Liberty grades Excel Project Part 4 with the rubric attached to the assignment in Canvas, worth 50 points in the published guide. That is about 5% of the course's 1,010 points. Open the rubric before you draft and read across each row: the top column describes what full credit looks like, and the gap between columns tells you what costs points.
Course grades in ACCT 370 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 (except Module/Week 1) 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 370 Week 7 method, step by step
Set up the data before the write-up
Work through the Excel Project Part 4 calculations or software steps first and save the output. The written part interprets those numbers, so they have to be right before you explain them.
Show the method
Say which method, formula or test you used and why it fits the question. Graders want to see that the choice was deliberate.
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 370, 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, Part 4).
Project one year first and check that the balance sheet balances before extending to further years. A common approach is to let cash or a revolving credit line be the balancing item, so that when projected assets exceed projected liabilities and equity, the gap shows up as borrowing needs, which is itself a useful finding for the report.
A structure for ACCT 370 Week 7 Excel Project Part 4
Word targets are planning numbers for about 900 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 | Sales growth, margins and other drivers, with reasons. | ~270 words |
| Projected income statement | Next year or years. | ~230 words |
| Projected balance sheet | That balances. | ~230 words |
| Notes | Why the assumptions are reasonable. | ~160 words |
A topic angle that works
Base each assumption on the history from Part 3 and management's guidance in the 10-K, and put the assumptions on their own tab so the projections update when you change them.
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.
Sales are projected to grow 4%, between the company's three-year average of 5% and management's guidance of low single-digit growth.1 Gross margin is held at last year's 33.5% because the 10-K describes no pricing or cost changes, and SG&A is set at 21% of sales, reflecting the cost program management announced.
- Grounded in history and guidance.
- One assumption per driver.
- Explained.
Mistakes that cost points on ACCT 370 Week 7
- Assumptions without reasons.
- A balance sheet that does not balance.
- Hard-coded projections.
Checklist before you submit
- Length: Excel workbook (Part 4)
- Sources: The historical statements and your assumptions
- 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 is in ACCT 370 Excel Part 4?
Projected financial statements.
How many points is ACCT 370 Week 7 Excel Project Part 4 worth?
50 points in Liberty's published course guide for ACCT 370, out of a course total of 1,010 points (about 5% of the grade). The rubric attached to the assignment in Canvas shows how those points are divided.
Is ACCT 370 Week 7 the same in every section of ACCT 370?
This guide follows Liberty's published course guide for ACCT 370. 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.