FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Copy Paste ?Format Panter
ID: 2510268 • Letter: F
Question
FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Copy Paste ?Format Panter Blu, Clipboard Formatting Font Alignment NumberG X Submission 1 (6 points)- due Tuesday April 10 before 5pm- You must submit your completed De ACC 3010 Project 3 Winter 2018 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 and the bonds formulas tab completed. Your file must be namad 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 10 Failure to use formulas for all of the project will result in points being deducted. If you just type in the numbers Asset aquistions planned deph Project Informationpctb financing options worksheet O Type here to search 3 5 6 7Explanation / Answer
Building Depreciation Schedule Depreciation for the Year Date Asset Cost Dep'ble Basis Rate Depn. Exp. Acc. Depn. Book Value 11/1/2018 465500 10/31/2019 465500 450000 3.33% 15000 15000 450500 10/31/2020 465500 450000 3.33% 15000 30000 435500 10/31/2021 465500 450000 3.33% 15000 45000 420500 10/31/2022 465500 450000 3.33% 15000 60000 405500 Office Equipment Depreciation Schedule Depreciation for the Year Date Asset Cost Dep'ble Basis Rate Depn. Exp. Acc. Depn. Book Value 4/1/2019 150500 10/31/2019 150500 140000 25% 20417 20417 130083 7 mths. 10/31/2020 150500 140000 25% 35000 55417 95083 10/31/2021 150500 140000 25% 35000 90417 60083 10/31/2022 150500 140000 25% 35000 125417 25083 10/31/2023 150500 140000 25% 14583 140000 10500 5 mths. (Salvage) Delivery Equipment Depreciation Schedule Depreciation for the Year Date Asset Cost Depn./ unit Units of prodn. Depn. Exp. Acc. Depn. Book Value 5/1/2019 200000 10/31/2019 200000 1.16 12560 14542 14542 185458 10/31/2020 200000 1.16 32560 37697 52239 147761 10/31/2021 200000 1.16 31650 36644 88883 111117 10/31/2022 200000 1.16 29850 34560 123442 76558 10/31/2023 200000 1.16 26500 30681 154124 45876 10/31/2024 200000 1.16 22350 25876 180000 20000 (Salvage)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.