Question
Use the following background information to answer the question provided. Please look at the attached image to determine if the interest expense calculations are correct/incorrect,
Use the following background information to answer the question provided. Please look at the attached image to determine if the interest expense calculations are correct/incorrect, and please provide an explanation.
Revenue | 2016 | 2017 | 2018 | |
Sales revenue | 35,000 | 60,000 | 80,000 | |
Total Revenues | 35,000 | 60,000 | 80,000 | |
Expenses | ||||
Advertising | 675 | 700 | 800 | |
Cost of goods sold | 10,000 | 20,000 | 40,000 | |
Depreciation Expense | 5,400 | 5,400 | 5,400 | |
Insurance | 1,120 | 1,120 | 1,120 | |
Interest expense | - | 769.06 | 1,459.71 | |
Rent | 3,000 | 3,000 | 3,000 | |
Salaries and wages | 1,000 | 4,000 | 5,000 | |
Travel | 1,250 | 1,500 | 2,000 | |
Telephone Expenses | 500 | 500 | 500 | |
Registration Expenses | 1,000 | 1,000 | 1,000 | |
Legal Expenses | 1,500 | 1,500 | 1,500 | |
Total Expenses | 25,445 | 39,489 | 61,780 |
Background:
Betty planned to apply for a local loan from the Southold Savings Bank for $10,000, which would have been received January 1, 2017. This loan was for a 5-year term with interest at 9%, annually paid monthly (60 monthly payments).
Question:
In Excel, prepare the Income Statement for Wools Vest. You need to compute the Interest Expense Amount annually. Go to www.bankrate.com.
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