Rosey's Roses Present and Future Values -
Future need: $15,000.00
Term (in years): 4
Interest rate: 6%
Find Annuity payment required: ?
Future need: $15,000.00
Term (in years): 4
Interest rate: 6%
Invest now: ?
Annuity investment: ($1,000.00)
Term (in years): 4
Interest rate: 5%
Future value: ?
Current investment: ($4,000.00)
Term (in years): 4
Interest rate: 5%
Future value: ?
Rosey's Roses Predicting Costs -
| Month |
Miles Driven |
Delivery Expense |
| Jan-12 |
5,400 |
$ 12,000 |
| Feb-12 |
5,700 |
$ 12,100 |
| Mar-12 |
6,300 |
$ 12,600 |
| Apr-12 |
4,200 |
$ 10,100 |
| May-12 |
7,500 |
$ 13,750 |
| Jun-12 |
3,500 |
$ 10,000 |
| Jul-12 |
8,000 |
$ 18,000 |
| Aug-12 |
5,300 |
$ 12,000 |
| Sep-12 |
5,100 |
$ 11,000 |
| Oct-12 |
4,700 |
$ 10,100 |
| Nov-12 |
6,300 |
$ 13,000 |
| Dec-12 |
7,500 |
$ 15,000 |
| Jan-13 |
10,200 |
$ 20,000 |
| Feb-13 |
8,800 |
$ 15,700 |
| Mar-13 |
7,500 |
$ 14,500 |
| Apr-13 |
6,900 |
$ 12,950 |
| May-13 |
7,900 |
$ 18,000 |
| Jun-13 |
7,200 |
$ 13,500 |
| Jul-13 |
9,500 |
$ 18,000 |
| Aug-13 |
9,800 |
$ 19,000 |
| Sep-13 |
11,300 |
$ 21,000 |
| Oct-13 |
12,500 |
$ 21,050 |
| Nov-13 |
6,500 |
$ 14,000 |
| Dec-13 |
5,900 |
$ 10,500 |
High Expense
Low Expense
Difference
Rosey's Roses - Allowance for Uncollectible Accounts
|
Aging Method Information
|
Current
|
0 - 30 Days Past Due
|
31 - 60 Days Past Due
|
61 - 90 Days Past Due
|
> 90 Days Past Due
|
Total
|
|
Amount
|
|
|
|
|
|
|
|
Past experience ratio
|
|
|
|
|
|
|
Past experience ratio for % of sales method
Facts:
Accounts receivable balance (beg)
Sales on account
Collections on account
Write-offs of accounts receivable
Accounts receivable balance (end)
Percentage of Sales Method:
Allowance for uncollectible accounts (beg)
Write-offs of accounts receivable
Uncollectible accounts expense
Allowance for Uncollectible accounts (end)
Aging Method:
Allowance for uncollectible accounts (beg)
Write-offs of accounts receivable
Uncollectible accounts expense
Allowance for uncollectible accounts (end)
Attachment:- Assignment.rar