How do I do a proration calculation in excel?
I'd like to take inputs from the user -
Amount to prorate
Starting date - date product purchased
end date - date of failure/warranty claim
base warranty period - period where coverage is 100%
prorated warranty period - Period where warranty is prorated. starts at day one regardless of base period.
Product is $400
Warranty claim 6/1/10
Base Warranty 24months
Prorated period 6 months
$400 is prorated for 30months