Reference no: EM131268560
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