Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Accounting Excel assignment, all instructions are present on the "instructions" sheet/ tab in the file, please read carefully

1 answer below »
Accounting Excel assignment, all instructions are present on the "instructions" sheet/ tab in the file, please read carefully
Answered Same Day Aug 01, 2021

Solution

Khushboo answered on Aug 02 2021
134 Votes
Grade
                                                You
                                                Marks
                                                2
                                                    grade manually
                                                    grade manually
                                                You
                                                Marks
                                                1    depreciable amount 2025
                                                0    rate 2023
                                                1    depreciation expense 2022
                                                1    accumulated depreciation 2027
                                                1    ca
ying amount 2027
                                                1    depreciable amount 2022
                                                0    rate 2023
                                                1    depreciation expense 2022
                                                1    accumulated depreciation 2026
                                                1    ca
ying amount 2026
                                                0    units of production 2024
                                                1    rate 2023
                                                1    depreciation expense 2022
                                                1    accumulated depreciation 2027
                                                1    ca
ying 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 co
ect side and account titles
                                                1    ca
ying amount 2025 same as SL schedule
                                                1    depreciable amount 2026
                                                0    rate 2026
                                                1    ca
ying 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", "Cu
ency" 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers