Answer To: Accounting Excel assignment, all instructions are present on the "instructions" sheet/ tab in the...
Khushboo answered on Aug 02 2021
Grade
Your
Marks
2
grade manually
grade manually
Your
Marks
1 depreciable amount 2025
0 rate 2023
1 depreciation expense 2022
1 accumulated depreciation 2027
1 carrying amount 2027
1 depreciable amount 2022
0 rate 2023
1 depreciation expense 2022
1 accumulated depreciation 2026
1 carrying amount 2026
0 units of production 2024
1 rate 2023
1 depreciation expense 2022
1 accumulated depreciation 2027
1 carrying amount 2027
0
0
0
0
0
Method Amount Gain/loss
0 1 1
0 1 1
0 1 1
0 Acc. Dep. Has to come from SL schedule
Gain/ Loss has to match part (h)
entry has to have debits/credits in correct side and account titles
1 carrying amount 2025 same as SL schedule
1 depreciable amount 2026
0 rate 2026
1 carrying amount 2029
Instructions
Assignment Instructions:
- This assignment must be done individually.
- This assignment is due on Tuesday July 28th at 11:59pm.
- You must submit an electronic copy through Brightspace.
Late assignments will not be accepted.
Required:
1 Download the assignment file from Brightspace.
2 Save the file as "Assignment 2 - Your last name".
3 Enter your Name and student number in the spaces below.
4 All data required for this assignment can be found in the Data tab.
5 All numbers MUST be presented in the proper number format ("Accounting", "Currency" or "Percentage")
6 Answer the questions in the "Answer" tab.
MAKE SURE TO CELL-REFERENCE YOUR NUMBERS FROM THE "DATA" TAB.
MARKS WILL BE DEDUCTED FOR TYPING IN NUMBERS ON THE ANSWER PAGE
7 Submit your assignment in Brightspace for grading.
Student Name and Student Number:
Student #
Enter in your full name (first name then last name) using proper capitalization
Data
Natalie is the CEO of Sugden Company. She is thinking of buying a van that will be used only for business. She estimates that she can buy the van for the price shown below. Natalie would spend an additional amount (shown below) to have the van painted. As well, she wants the back seat of the van removed so that she will have lots of room to transport her juicer inventory and smoothies and...