College: Yuba Community CollegeCourse: Accounting 1 LAB (online)Platform/Website: Canvas...

Question

College: Yuba Community CollegeCourse: Accounting 1 LAB (online)Platform/Website: Canvas (yccd.instructure.com)Email:  XXXXXXXXXXPassword: Evangel19This is a lab assignment for my Financial Accounting Lab (1A) class at Yuba Community College. Attached is assignment excel spreadsheet. Complete the assignment and submit it to me here at topassignmentexperts.com and I will upload it to my canvas portal. The name of the lab assignment for this week is "DEPREC". It is due by 11:59 on Monday, April 19, 2021.*****MUST INCLUDE:*****- What if Section- Chart Analysis Section- Tickler Section

Bhavani · Accepted Answer

Worksheet
	DEPREC
	Depreciation
	Data Section
		Cost of asset		$350,000
		Estimated salvage value		$30,000
		Estimated useful life in years		4
		Estimated life in units (miles, etc.)*		100,000
			*Estimated
		Year	Units
		1	30,000
		2	20,000
		3	40,000
		4	10,000
		5	0
		6	0
		7	0
		8	0
	Answer Section
			Depreciation Expense
					Double
			Straight	Units of	Declining
		Year  	Line	Production	Balance
		1	$80,000	$96,000	$175,000
		2	80,000	64,000	87,500
		3	80,000	128,000	43,750
		4	80,000	32,000	13,750
		5	0	0	0
		6	0	0	0
		7	0	0	0
		8	0	0	0
		Total  	$320,000	$320,000	$320,000
Sheet1
	FALL 20 MYERS CPA
Chart  analysis
											DECPREC5
				Worksheet  chart
			Work sheet					DEPREC5
			Chart					Chart
			Data Table					Data Table
		1	$80,000	$96,000	$175,000		1	$8,750	$11,200	$18,750
		2	$160,000	$160,000	$262,500		2	$17,500	$22,400	$32,813
		3	$240,000	$288,000	$306,250		3	$26,250	$33,600	$43,359
		4	$320,000	$320,000	$320,000		4	$35,000	$44,800	$51,270
		5	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		5	$43,750	$56,000	$57,202
		6	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		6	$52,500	$60,667	$70,000
		7	ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		7	$61,250	$65,

College: Yuba Community College Course: Accounting 1 LAB (online) Platform/Website: Canvas (yccd.instructure.com) Email: XXXXXXXXXX Password: Evangel19 This is a lab assignment for my Financial...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment