Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Accounting for Governmental and Not-for-Profit Organizations

Authors: Paul Copley

12th edition

0078025818, 978-0078025815

More Books

Students also viewed these Accounting questions

Question

What are the limitations of each of each of these methods

Answered: 1 week ago