Billed In Amount Collection Probability (%) Accounts Receivable November 2019 ...

Question

Billed In	Amount	Collection Probability (%)	Accounts Receivable
November 2019	$3,000,000.00	100.0
October 2019	$1,500,000.00	100.0
September 2019	$500,000.00	97.5
August 2019	$400,000.00	95.0
July 2019	$300,000.00	90.0
June 2019	$200,000.00	85.0
May 2019	$100,000.00	80.0
April 2019	$100,000.00	75.0
March 2019	$50,000.00	50.0
February 2019	$100,000.00	25.0
January 2019	$50,000.00	10.0

Sum of digits depreciation
Useful Life
Asset value
Salvage Value
Depreciation

Year	Remaining Years	Depreciation Amount

Double declining balance depreciation
Asset acquisition cost
Salvage Value
Depreciable amount
Depreciable life
Annual Percent

Year	Depreciation Amount	Total

Month	Billing Amount	Collections	Expenses	Cash Flow	Cash Balance
Jul 2023	$100,000.00
Aug 2023	$100,000.00
Sept 2023	$100,000.00
Oct 2023	$100,000.00
Nov 2023	$100,000.00
Dec 2023	$100,000.00
Jan 2024	$100,000.00
Feb 2024	$100,000.00
Mar 2024	$100,000.00
Apr 2024	$100,000.00
May 2024	$100,000.00
Jun 2024	$100,000.00

Nitish Lath · Accepted Answer

Problem 2.1
	Billed In	Amount	Collection Probability (%)	Accounts Receivable	Cumulative receivable
	November 2019	$3,000,000.00	100.0	0	282500
	October 2019	$1,500,000.00	100.0	0	282500
	September 2019	$500,000.00	97.5	12500	282500
	August 2019	$400,000.00	95.0	20000	270000
	July 2019	$300,000.00	90.0	30000	250000
	June 2019	$200,000.00	85.0	30000	220000
	May 2019	$100,000.00	80.0	20000	190000
	April 2019	$100,000.00	75.0	25000	170000
	March 2019	$50,000.00	50.0	25000	145000
	February 2019	$100,000.00	25.0	75000	120000
	January 2019	$50,000.00	10.0	45000	45000
Problem 2.

Billed In Amount Collection Probability (%) Accounts Receivable November 2019 $3,000,000.00 100.0 October 2019 $1,500,000.00 100.0 September 2019 $500,000.00 97.5 August 2019 $400,000.00 95.0 July...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment