Question

In: Accounting

TERM Invoice Amount Invoice NAME Start End 5452952 11/30/2013 10/31/2015 69,500.00 8188 8/1/2013 7/31/2014 1,000.00 8189...

TERM Invoice Amount
Invoice NAME Start End
5452952 11/30/2013 10/31/2015 69,500.00
8188 8/1/2013 7/31/2014 1,000.00
8189 8/1/2014 7/31/2015 1,000.00
3686223 3/11/2014 12/18/2014 1,166.67
3664490 12/19/2013 12/18/2014 5,800.00
USINV-022647 5/29/2014 5/28/2015 7,600.00
00091849 12/26/2013 7/25/2014 500.00
00082204 7/26/2014 7/25/2015 750.00

The above includes information pertaining to the terms and invoice amounts of several prepaid expenses. Calculate the monthly amortization using the quarter of a month depreciation method (.25, .5, .75).

Solutions

Expert Solution

prepaid expenses 69,500.00 1,000.00 1,000.00    1,166.67 5,800.00 7,600.00      500.00      750.00
no. of months 23 12 12 9 12 12 7 12
per month      3,021.74        83.33        83.33       129.63      483.33      633.33        71.43        62.50
ddd/mm/yr 30-11-2013 1/8/2013 1/8/2014 11/3/2014 19/12/13 29/5/14 26/12/13 26/7/14
31-10-2015 31/7/14 31/7/15 18/12/14 18/12/14 28/5/15 25/7/14 25/7/15
2013
Aug            83.33
Sept        83.33
Oct        83.33
Nov         755.44        83.33
Dec      3,021.74        83.33      241.67        17.86
2014 Jan      3,021.74        83.33      483.33        71.43
Feb      3,021.74        83.33      483.33        71.43
Mar      3,021.74        83.33         97.22      483.33        71.43
Apr      3,021.74        83.33       129.63      483.33        71.43
May      3,021.74        83.33       129.63      483.33      158.33        71.43
June      3,021.74        83.33       129.63      483.33      633.33        71.43
July      3,021.74        83.37       129.63      483.33      633.33        53.56        15.63
Aug      3,021.74        83.33       129.63      483.33      633.33        62.50
Sept      3,021.74        83.33       129.63      483.33      633.33        62.50
Oct      3,021.74        83.33       129.63      483.33      633.33        62.50
Nov      3,021.74        83.33       129.63      483.33      633.33        62.50
Dec      3,021.74        83.33         32.41      241.70      633.33        62.50
2015 Jan      3,021.74        83.33      633.33        62.50
Feb      3,021.74        83.33      633.33        62.50
Mar      3,021.74        83.33      633.33        62.50
Apr      3,021.74        83.33      633.33        62.50
May      3,021.74        83.33      475.04        62.50
June      3,021.74        83.33        62.50
July      3,021.74        83.37        46.87
Aug      3,021.74
Sept      3,021.74
Oct      2,266.29

Related Solutions

INVOICE NAME TERM START TERM END INVOICE AMOUNT 3/6/2014 3/6/2015 4,670.00 3/6/2013 3/6/2014 4,670.00 20140307_3_PL 3/7/2014...
INVOICE NAME TERM START TERM END INVOICE AMOUNT 3/6/2014 3/6/2015 4,670.00 3/6/2013 3/6/2014 4,670.00 20140307_3_PL 3/7/2014 3/7/2015 10,000.00 20584307_3_PL 3/7/2013 3/7/2014 9,000.00 PLN-02983 3/31/2014 3/30/2015 1,500.00 71588 4/1/2014 4/1/2015 3,228.00 713423 5/23/2014 3/31/2015 10,416.00 11234 1/1/2014 12/31/2014 1,000.00 The above includes information pertaining to the terms and invoice amounts of several prepaid expenses. Calculate the monthly amortization using the quarter of a month depreciation method (.25, .5, .75). Quarter of a month method of depreciation.
3/11/2014 12/18/2014 1,166.67 12/19/2013 12/18/2014 5,800.00 5/29/2014 5/28/2015 7,600.00 12/26/2013 7/25/2014 500.00 7/26/2014 7/25/2015 750.00 1/1/2014...
3/11/2014 12/18/2014 1,166.67 12/19/2013 12/18/2014 5,800.00 5/29/2014 5/28/2015 7,600.00 12/26/2013 7/25/2014 500.00 7/26/2014 7/25/2015 750.00 1/1/2014 12/31/2014 4,200.00 3/6/2014 3/6/2015 4,670.00 3/6/2013 3/6/2014 4,670.00 The above information contains the terms and invoice amounts for several prepaid expenses. Calculate the monthly amortization for each (include equations) and determine the balances for each as of 12/31/2014. Use quarter of a month depreciation.
Amount spent # of students cumulative frequency 1 -10 3 3 11-20 7 10 21-30 9...
Amount spent # of students cumulative frequency 1 -10 3 3 11-20 7 10 21-30 9 19 31-40 11 41-50 8 51-60 2 (a) complete the table to show the cumulative frequency (b) using the scale of 1 cm to represent $5 on the horizontal axis and 1cm to represent 5 students on the vertical axis, draw the cumulative frequency graph for the data. (marks will be awarded for axis appropriately labelled, points correctly plotted and a smooth curve carefully...
Client Name: Apple Inc. Budget Actual For the Period Ended: 9/30/17 Start Date: 7/31/17 Nature of...
Client Name: Apple Inc. Budget Actual For the Period Ended: 9/30/17 Start Date: 7/31/17 Nature of Assignment: Integrated Audit End Date: 10/31/17 Hours: 36,000 Audit steps for tests of controls, balances, transactions, analytical procedures, etc. as well as other considerations such as sample size and sample methodology. (a) (b) (c) (d) (e) (f) (g) WP Requirement Procedure Comp Notes and Evidence Date Init. 8.0 (Acquisition) 8.1 8.2 8.3 8.4 8.5 8.6 8.7 8.8 9.0 (Payment) 9.1 9.2 9.3 9.4 9.5...
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Match No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Player A 8 42 56 68 91 123 12 46 57 137 5 80 14 10 19 Player B 38 44 46 59 57 61 48 42 51 39 58 41 55 45 68 1. For the given data set representing the runs scored by two players in last 15 matches, conduct the following analysis: i. Which average you will use to summarize...
Period   0 1 2 3 4 5 6 7 8 9 10 11 PBP NPV IRR...
Period   0 1 2 3 4 5 6 7 8 9 10 11 PBP NPV IRR Project A $                       (1,000,000) $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 400,000 Project B $                       (1,000,000) $ 500,000 $ 500,000 $ 500,000 Project C $                             (80,000) $      1,040 $      9,456 $    11,405 $    18,567 $    47,453 $      6,394 $    45,727 $    51,933 $    85,625 Project D $                           (400,000) $      4,161...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903 Monthly Revenue Growth...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12...
Input Data Month 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Revenue $             -   $            -   $            -   $        -   $        -   $         -   $    2,500 $    2,875 $    3,306 $    3,802 $    4,373 $    5,028 $    5,783 $    6,650 $    7,648 $      8,795 $   10,114 $   11,631 $   13,376 $   15,382 $   17,689 $   20,343 $   23,394 $   26,903 Monthly Revenue Growth...
Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11...
Post Position 1 2 3 4 5 6 7 8 9 10 Wins 19 14 11 15 15 7 8 12 5 11 The table below lists the frequency of wins for different post positions in the Kentucky Derby horse race. Use a 0.05 significance level to test the claim that the likelihood of winning is the same for the different post positions. What is the critical value (the X2 value)? [Round to the nearest thousandths place]
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5...
3 6 4 8 1 10 2 9 11 12 15 22 3 6 7 5 8 1 12 14 Each column represents a different treatment given to sick rats. Each cell is a different rat. Use statistical analysis and use post hoc testing using contrasts to find the best treatment. Treatment 1: vitamins Treatment 2: prescription pills Treatment 3: brain surgery Treatment 4: shock therapy Treatment 5: dietary changes
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT