Submission 1 (6 points) - due Tuesday April 10 before 5pm - You must submit your completed Depreciation schedules and the Depreciation formulas tab. Your file must be named correctly - "Your name (first and last) Project 3 part 1. Failure to name your file correctly will result in a 1 point deduction

Submission 2 (12 points ) - due Tuesday April 17 before 5pm - You must submit your completed Bonds portion of the financining options tab and the Bonds portion of the partial balance sheets. . Your file must be named correctly - "Your name (first and last) Project 3 part 2. Failure to name your file correctly will result in a 1 point deduction

Submission 3 (12 points) - due Tuesday April 24 before 5pm - You must submit your total excel file with the equity option section of the financing options worksheet tab completed, the equity option section of the partial balance sheets tab completed, the ratios tab completed, the choice and reasons tab completed, and the balance sheet and ratios formula tabs completed. Your file must be named correctly - "Your name (first and last) Project 3 part 3. Failure to name your file correctly will result in a 1 point deduction

		NFT Consulting and Sales Inc
		Post Closing Trial Balance
		October 31, 2018
Cash		$ 304,900
Accounts Receivable		76,580
Allowance for Uncollectible Accounts			$ 5,690
Supplies		56,500
Inventory		68,596
Prepaid Insurance		57,890
Land		260,000
Building		550,000
Accumulated Depr Building			25,650
Office Equipment		856,850
Accumulated Depr Office Equip			22,500
Computer Equipment		556,500
Accumulated Depr - Computer Equip			10,250
Accounts Payable			56,560
Utilities Payable			16,850
Wages Payable			58,950
Interest Payable			25,000
Long term Note Payable			390,000
Mortgage Payable			406,800
Common Stock ($1 par, 1,000,000,			400,000
shares authorized, 400,000 issued
and outstanding)
Retained Earnings			1,369,566
		$ 2,787,816	$ 2,787,816

Additional information related to the $200,000 delivery equipment purchase: It is ESTIMATED that the equipment will be ABLE TO DRIVE 150,000 total miles over its lifetime. To complete the depreciation schedule, PRESUME that the actual miles driven for its useful life are as indicated below. Also, round depreciation expense per unit to the nearest cent and depreciation expense to the nearest dollar.
	Year 1	12,560
	Year 2	32,560
	Year 3	31,650
	Year 4	29,850
	Year 5	26,500
	Year 6	22,350
		155,470

Building Depreciation Schedule
		Depreciation for the Year
	Asset	Dep'ble		Depreciation	Accumulated	Book
Date	Cost	basis	Rate	Expense	Depreciation	Value
11/1/2018
10/31/2019
10/31/2020
10/31/2021
10/31/2022
Office Equipment Depreciation Schedule
		Depreciation for the Year
	Asset	Dep'ble		Depreciation	Accumulated	Book
Date	Cost	basis	Rate	Expense	Depreciation	Value
4/1/2019
10/31/2019
10/31/2020
10/31/2021
10/31/2022
10/31/2023
Delivery Equipment Depreciation Schedule
		Depreciation for the Year
		Depreciation
	Asset	per unit	Units of	Depreciation	Accumulated	Book
Date	Cost		Production	Expense	Depreciation	Value
5/1/2019
10/31/2019
10/31/2020
10/31/2021
10/31/2022
10/31/2023
10/31/2024