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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!