Question

In: Accounting

Prepare the answer to the following question by either entering text directly or uploading an Excel...

Prepare the answer to the following question by either entering text directly or uploading an Excel or Word file. Do NOT upload a .pdf or .jpg file or you will receive zero credit. Show computations.

The prepaid insurance account has an unadjusted balance of $46,000 at December 31, 2018, the end of Hanson Company's accounting year. Insurance expense has an unadjusted $2,000 balance at the same point in time. Some policies that were in effect have expired. Some of those were renewed and some were not. The following policies are in effect at December 31, 2018:

Policy                                                                 Date                 Policy            Total Premium

  Type                                                               Acquired             Term         Paid when acquired

Liability                                                              1-31-17          2 years         $48,000

Auto                                                                   6-30-18             2 years             9,000

Business interruption 8-1-18              1 year                 840

  1. Determine the adjusted balance in prepaid insurance at December 31, 2018.

2.Determine the amount of total insurance expense (you need not separate the expense by policy type) to report on the income statement for the year ended December 31, 2018.

Solutions

Expert Solution

1. Computation of Adjusted balance in Prepaid Insurance at Dec 31, 2018
Policy Type Date Acquired Policy Term Total Premium paid when Acquired (A) Insurance Expenses Booked in prior Year (B) To be Booked in Insurance Expense during 2018 ( C ) Adjusted Balance in prepaid insurance on 2018 ( A-B-C)
Liability 31/01/2017 2 Year $48,000 $46,000 $2,000 $0
Auto 30/06/2018 2 Year $9,000 $0 $9000/24*6 =$2250 $9000/24*18=$6750
BI 1/8/2018 1 Year $840 $0 $840/12*7=$490 $840/12*5=$350
Total Insurance $57,840 $46,000 $4,740                                                    $7,100
2. Statement Showing Insurance expense to be report in Income Statement in Dec 31 2018
Insurance Expense balance $2,000.00
Insurance Expense adjusted from Prepaid Insurance $4,470.00
Total Insurance $6,470.00

Related Solutions

Prepare the answer to the following question by either entering text directly or uploading an Excel...
Prepare the answer to the following question by either entering text directly or uploading an Excel or Word file. Do NOT upload a .pdf or .jpg file or you will receive zero credit. Show computations. The prepaid insurance account has an unadjusted balance of $46,000 at December 31, 2018, the end of Hanson Company's accounting year. Insurance expense has an unadjusted $2,000 balance at the same point in time. Some policies that were in effect have expired. Some of those...
THIS IS THE SECOND TIME I AM UPLOADING THIS QUESTION - PLEASE READ THE REQUIREMENT! ANSWER...
THIS IS THE SECOND TIME I AM UPLOADING THIS QUESTION - PLEASE READ THE REQUIREMENT! ANSWER IN 150 WORDS OR LESS! Section 1 (3 marks: You can start this section after Week 4 lecture) Read the following article: Harford, T. (2014), ‘Big data: A big mistake?’, Significance 11(5), 14–19. Question: Critically evaluate the main points of the article using three bullet points, in less than 150 words in total. Critical evaluation means To give your opinion on something To support...
Read the lecture for Chapter 7, the following text and then answer the question at the...
Read the lecture for Chapter 7, the following text and then answer the question at the end. Notice the grading criteria this week is different than other weeks Constructors Constructor methods inside a class are methods that determine how an object is going to be created when some program instantiate one of them using the “new” clause. Their main use is to initialize the object’s instance variables. For example, last week I presented the Chair class that represented chairs. This...
Either graphically or using text answer the following:Describe the response of a central bank to a...
Either graphically or using text answer the following:Describe the response of a central bank to a permanent negative supply shock (fall in ye.) Describe the response of a central bank to a permanent negative demand shock (leftward shift of IS) Compare the two scenarios.
IN PYTHON Complete the following tasks, either in a file or directly in the Python shell....
IN PYTHON Complete the following tasks, either in a file or directly in the Python shell. Using the string class .count() method, display the number of occurrences of the character 's' in the string "mississippi". Replace all occurrences of the substring 'iss' with 'ox' in the string "mississippi". Find the index of the first occurrence of 'p' in the string "mississippi". Determine what the following Python function does and describe it to one of your Lab TAs : def foo(istring):...
Plot the following parabolic functions in Excel and then answer the discussion question below . Use...
Plot the following parabolic functions in Excel and then answer the discussion question below . Use at least 8 points for each plot: Each graph is worth 15 points and must include 8 points. 1) y=x2-6x+8 2) y=x2+4 3) y=(-1/2)(x2) 4) What is the maximum number and the minimum number of x-intercepts for a parabola? Why? (15 points) In order to obtain full credit, you will need to plot the functions in Excel or using the Open Office feature and...
Use Excel to answer the following question: The capital fund for research project investment at a...
Use Excel to answer the following question: The capital fund for research project investment at a corporation is limited to $100,000 for next year. The company uses an MARR of 15% per year. There are three independent project proposals (i.e., none, one or more can be selected) with pertinent information given in the below table. Project Initial Investment ($) Annual Net Cash Flow ($/year) Life (years) Salvage Value ($) A -25,000 6,000 4 4,000 B -30,000 9,000 4 -1,000 C...
Answer the following question What are some of the advanced features for modeling available in Excel?...
Answer the following question What are some of the advanced features for modeling available in Excel? Based on what many of you have already seen of Excel in CS105, are you surprised that Excel has so many capabilities? Do you use Excel for anything other than school work today?  
Compute in excel Text Question 8.3.8 (Confidence Interval for a Mean, not a proportion) (adapted) The...
Compute in excel Text Question 8.3.8 (Confidence Interval for a Mean, not a proportion) (adapted) The Table below contains the percentage of women receiving prenatal care in 2009 for a sample of countries. (i) Find the 90% confidence interval for the average percentage of woman receiving prenatal care in 2009 using the normal distribution. (Express as percentages with two digits, as shown in the data.) (ii) Find the 90% confidence interval for the average percentage of woman receiving prenatal care...
using java, parse a text file to answer the following question: -list sentences with the maximum...
using java, parse a text file to answer the following question: -list sentences with the maximum number of occurences of the word “the” in the whole file and also list the corresponding frequency. (cannot use hash maps) example output: the:3:The day had came to leave before the storm. What hit the back bumper of the car before the window cracked? The classroom doors where shut closed before the students open the project.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT