Accounting - Excel

assignment_1301template_for_upload.xls

Checklist


	CHECKLIST
	Make sure you fill this in AFTER you have finished the assignment and BEFORE you submit it
		I declare that this is an original assignment and is entirely my own work
		This assignment has been prepared exclusively by me for this paper and has not and will not be submitted as assessed work in any other paper
		I am aware of the Code of Student Conduct on the Massey University web site, clause 2 (f), where in it states [Students shall] “act with honesty and integrity in submitting material or imparting information to the university”. Assessment & Examination Regulations clause (6) clarifies further that “dishonesty” is a breach of the Code of Student Conduct and will be dealt with accordingly
		I have used the correct naming convention when naming both my files. (88888888XXXX - where 88888888 is replaced by your student ID number and XXX is your surname)

ASSIGNMENT 1301
		INPUT DATA
	MONTHS COVERED BY:
	Quarter	3	months
	Year (annual)	12	months
	OPENING BALANCES 1/10/13
	Cash at Bank
	Accounts Receivable
	Inventories
	Accounts Payable
	General creditors
	SALES DATA
	Estimated Selling Price per trailer
	Collection period
	Percentage in month of sale
	Percentage in following month
	Estimated Monthly Sales Volume
	October		units
	November		units
	December		units
	INVENTORY DATA
	Estimated Cost price per trailer
	Required inventory level		units
	OTHER FORECAST PAYMENTS
	Advertising		per month
	General (Telephone, Utilities, Stationery, ISP etc)		per month
	Owner's personal withdrawals		per month
	Insurance premium p.a. (payable 12 October)		per year
	Rent		per month
	Vehicle expenses		per month
	Ute (payable 20th October)
	NON-CURRENT ASSETS
	Straight line method is used for all non-current assets	Cost	Expected	Residual
		$	Life	Value $
	Ute
	Computer Equipment
	FORECAST RECEIPTS
	From owner 1/10/13

ASSIGNMENT 1301
SALES COLLECTION BUDGET & DEPRECIATION
			OUTPUT AREA
	SALES, COGS and COLLECTION BUDGET
		October	November	December	Quarter
		$	$	$	$
	Sales Revenue
	Cost of Goods Sold
	Cash Collection
	Month of sale
	Month after
	Total
	PURCHASES BUDGET	Units	Units	Units	Units
	Budgeted total unit sales
	Add desired ending inventory in units
	Total required
	Less beginning inventory in units
	Budgeted purchases in units
		$	$	$	$
	Cost of purchases in dollars
	Cash payments for purchases
	ANNUAL DEPRECIATION
	Straight line method is used for all non-current assets
		$
	Ute
	Computer Equipment
	Total Depreciation

ASSIGNMENT 1301
CASH FLOW	OUTPUT AREA
Trump Trailers
Cash Flow Forecast
	October	November	December	Quarter
	$	$	$	$
Cash Flow from Operating Activities
Inflow
Total Inflow
Outflow
Payments to Inventory Suppliers
General
Insurance premium p.a. (payable 12 October)
Total outflow
Net Cash Inflow (outflow) from operations
Cash Flow Investing Activities
Inflow
Total Inflow
Outflow
Total outflow
Net cash inflow (outflow) from investing
Cash Flow Financing Activities
Inflow
Total Inflow
Outflow
Total Outflow
Net cash inflow (outflow) from Financing
Net cash inflow (outflow)
Beginning cash balance
Ending cash balance

 I declare that this is an original assignment and is entirely my own work.

 Where I have made use of the ideas of other writers, I have acknowledged (referenced) the

source in every instance.

 Where I have used any diagrams or visuals produced by others, I have acknowledged

(referenced) the source in every instance.

 This assignment has been prepared exclusively by me for this paper and has not been and

will not be submitted as assessed work in any other academic paper.

 I am aware of the Code of Student Conduct on the Massey University web site

http://calendar.massey.ac.nz/statutes/dr.htm , clause 2 (f), wherein it states [Students shall]

“act with honesty and integrity in submitting material or imparting information to the

university”. Assessment & Examination Regulations clause (6) clarifies further that

“dishonesty” is a breach of the Code of Student Conduct and will be dealt with accordingly.

I have run the checker macro (pressed Ctrl+k) and it accepts my spreadsheet as valid