Answered step by step
Verified Expert Solution
Question
1 Approved Answer
STEP 1: INPUTS - Enter numbers in the yellow highlighted fields following the instructions. Accounts Receivable: Enter a number between 90,000 and 100,000 Allowance
STEP 1: INPUTS - Enter numbers in the yellow highlighted fields following the instructions. Accounts Receivable: Enter a number between 90,000 and 100,000 Allowance for Doubtful Accounts: 2% of the A/R number is uncollectible Fixed Asset: Enter a number between 400,000 and 450,000 Useful Life: Enter a number of years between 4 and 8 Accounts Payable: Enter a number between 25,000 and 35,000 Notes Payable: Enter a number between 90,000 and 100,000 Bonds Payable: Enter a number between 40,000 to 60,000 (calculate 2% of your chosen A/R number) You will be calculating only 4 years of depreciation in Step 2, regardless of the number you choose. STEP 2: CALCULATIONS 2A) Calculate Depreciation on the Fixed Asset number you chose in cell B9, using the Double Declining Balance Method. Show your resulting calculation in the appropriate boxes in this spreadsheet. Do not make any formatting changes to the table. Double Declining Balance Method Depreciation Calculation. Original Purchase 2B) Calculate simple Interest on your Note Payable at a rate of Interest is accrued monthly. What is the interest Payable for 1 month (i.e. on July 31) What is the interest payable to date (i.e. up to Dec 31) What is the total payable on the note including interest at Dec 31, 2022 Useful life is 0 years Cost $ Depreciation Expense Accumulated Depreciati Book Value $ $ $ 2018 2019 2020 2021 7.00% The Note was taken out on July 1, 2022 and will be paid back on Jan 31, 2023 in full including all interest. It is currently Dec 31, 2022.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started