Financial Plan Final Draft

Anonymous
timer Asked: May 20th, 2019
account_balance_wallet $20

Question Description


Continued from last week. Complete the remainder of the plan by developing the following:

  1. Year 2: Quarterly income statements and cash flows; year-end balance sheet.
  2. Years 3-5: Year end statements of income, cash flow and balance sheet. (Note: if you are using the Moyes template go to 5 years; if you used the SCORE template, it only goes to 3 years—don't jump through hoops to do years 4 and 5.

Note: Use the same spreadsheet you started with last week. Hopefully you used one of the available templates and this is just a matter of adding on more years. Be sure to include the key assumptions from last week on one of the sheets of the workbook.
Please combine both assignments into the final draft which includes the components in this order:

  1. A list of key assumptions that drive your financial model. It is strongly encouraged that you find comparable companies and use industry ratios to justify your assumptions.
  2. Year 1: Monthly and year-end income statements and cash flows; year-end balance sheet.
  3. Year 2: Quarterly income statements and cash flows; year-end balance sheet.
  4. Years 3-5: Year end statements of income, cash flow and balance sheet.
Grading Criteria AssignmentsMaximum Points
Meets or exceeds established assignment criteria40
Demonstrates an understanding of lesson concepts20
Clearly presents well-reasoned ideas and concepts30
Uses proper mechanics, punctuation, sentence structure, and spelling10
Total100

Tutor Answer

Perfectsolutions
School: UCLA

Howdy! 👋 How's the going? I'm through with your task and it's ready for your review. 🔍 Kindly engage me for any edits or clarifications whatsoever. Please leave me a five star rating to build my profile. 😀 Also, don't hesitate to invite me to bid on your future assignments. 📚 Cheers buddy.

Quality Cakes Company
By: Your name
Income Statement
Years 1 to 5
($)
Year 1
NET REVENUES

Year 2

Year 3

Year 4

Year 5

200,000

300,000

350,000

400,000

450,000

COST OF REVENUE
% of Revenues

10,000
5%

15,000
5%

30,000
9%

50,000
13%

70,000
16%

GROSS PROFIT
% of Revenues

190,000
95%

285,000
95%

320,000
91%

350,000
88%

380,000
84%

50000
10000
10000
20000
4%

60000
10000
20000
30000
0%

84000
20000
40000
50000
0%

90000
20000
40000
50000
0%

120000
30000
40000
50000
0%

170,000

255,000

270,000

300,000

330,000

60000

40000

60000

64000

72000

230,000

295,000

330,000

364,000

402,000

74000

43000

80000

24000

43000

304,000

338,000

410,000

388,000

445,000

23000

23000

23000

23000

30000

OPERATING EXPENSES
Sales & Marketing
Research & Development
General and Administration
Total Operating Expenses
% of Revenues
EARNINGS FROM OPERATIONS
EXTRAORDINARY INCOME / (EXPENSE)
EARNINGS BEFORE INTEREST & TAXES
INTEREST INCOME / (EXPENSE)
NET EARNINGS BEFORE TAXES
TAXES
NET EARNINGS
% of Revenues

327,000 361,000 433,000
1.635 1.203333 1.237143

411,000 475,000
1.0275 1.055556

Company
By: Your name
Cash Flow Statememt
Year 1 by Months

Cash Flow Statement
Year 1 by Months
Month 1
OPERATING ACTIVITIES
Net Earnings
Depreciation
Working Capital Changes
(Increase)/Decrease Accounts Receivable
(Increase)/Decrease Inventories
(Increase)/Decrease Other Current Assets
Increase/(Decrease) Accts Pay & Accrd Expenses
Increase/(Decrease) Other Current Liab
Net Cash Provided/(Used) by Operating Activities

Month 2

Month 3

Month 4

8000
0

12000
0

...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors