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 | 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).
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 SolutionsINVOICE 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
Latest Questions
ADVERTISEMENT
|