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.
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...
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...
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.
Refer to the text to answer the following question(s). Casey Brickly opened ​The Landing​, a convenience...
Refer to the text to answer the following question(s). Casey Brickly opened ​The Landing​, a convenience store on the North Shore of Witmer Lake, in 1962. With a sandwich counter on one side and a bait shop and grocery on the other, ​The Landing​ was an immediate hit with weekend lake visitors and local residents alike. In the summer, boaters parked at the piers and bought all their fishing needs, such as rods and reels, bait, snacks, and soft drinks...
How do i answer the following question on excel? Consider attending one of the following two...
How do i answer the following question on excel? Consider attending one of the following two colleges as a full-time student. One is a public university with low tuition, while the other is a prestige university (they are both in the same city, so housing costs should be equal for each). Suppose you qualify for a partial scholarship at the private university. The financial information corresponding to attending each school is as follows. Public university ​ Private University Tuition and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT