20at

.xls
School
Lamar University **We aren't endorsed by this school
Course
ACCT MISC
Subject
Accounting
Date
Oct 31, 2023
Pages
4
Uploaded by DrInternetDonkey36 on coursehero.com
page 1 of 4 Fields to be Input by Preparer Fields calculated and populated by worksheet A. Preneed Price B. At-Need Price Funeral Home Basic Service $ - $ - $ - $ - Embalming $ - $ - $ - $ - Bathing Body $ - $ - $ - $ - Cosmetic /Beautician $ - $ - $ - $ - Dressing/Casketing $ - $ - $ - $ - Refrigeration $ - $ - $ - $ - Other - $ - $ - $ - $ - Rosary/prayer service $ - $ - $ - $ - Viewing/Visitation (# of days) $ - $ - $ - $ - Service at Funeral Home $ - $ - $ - $ - Service at other facility $ - $ - $ - $ - Memorial Service $ - $ - $ - $ - Graveside Service $ - $ - $ - $ - Direct Cremation $ - $ - $ - $ - Other - $ - $ - $ - $ - 1 Transfer remains to F.H. $ - $ - $ - $ - Hearse $ - $ - $ - $ - Family car $ - $ - $ - $ - Limousine(s) $ - $ - $ - $ - Pallbearer Car $ - $ - $ - $ - Clergy Car $ - $ - $ - $ - Flower Car $ - $ - $ - $ - Other - $ - $ - $ - $ - 2 Casket: $ - $ - $ - $ - Outer Burial Container: $ - $ - $ - $ - Alternative Container: $ - $ - $ - $ - Urn or Cremation Container: $ - $ - $ - $ - Other - $ - $ - $ - $ - Section I Subtotal $ - $ - $ - $ - $ - $ - A. Preneed Price B. At-Need Price Fields to be Input by Preparer Cemetery Open/Close Cemetery Set-Up (tent/chairs) Crematory Fees Clergy Honorarium Police Escorts Death Certificates Flowers Musician Obituary Services Public Transportation Purchaser Name: Other - Section II Subtotal $ - $ - Contract Number: "Automated" Preneed to At-Need Reconciliation Worksheet For Contracts With Non-Guaranteed Cash Advance Items I. Guaranteed Services and Merchandise C. Inflation Discount if B>A D. Item on At-Need not on Preneed E. Credit for Unused Preneed item F. Price Adjustment if A>B II. Non-Guaranteed Services and Merchandise III. Other Information 1.) Discount Reflected on Preneed Contract 2.) Amount Owed on Preneed Contract 3.) Other Discounts Given on At-Need Contract 4.) Total Earnings Attributable to the Preneed Contract 5.) Service/Merchandise Upgrade Amount Due - Must Be Calculated on a Comparable Time-Price Basis 6.) Service/Merchandise Downgrade Credit Due - Must Be Calculated on a Comparable Time-Price Basis
page 2 of 4 "Automated" Preneed to At-Need Reconciliation Worksheet For Contracts With Non-Guaranteed Cash Advance Items Sections I and II Total $ - $ -
Page 2 of 2 V. Non-Guaranteed Cash Advance Items Calculation $ - $ - $ - $ - #DIV/0! #DIV/0! $ - #DIV/0! #DIV/0! VI. Preneed and At-Need Contract Reconciliation Preneed At-Need $ - $ - $ - $ - (-) $ - (-) $ - (-) $ - + $ - + $ - - #DIV/0! + / - 18. Subtotals $ - #DIV/0! = $ - $ - #DIV/0! Preparer's Signature: Purchaser Name: Date: Contract Number: "Automated" Preneed to At-Need Reconciliation Worksheet For Contracts With Non-Guaranteed Cash Advance Items IV. Calculation of Proportionate Amount of Interest to Be Applied Towards Non-Guaranteed Items 1. Total Preneed Contract Price 6. Total of Non-Guaranteed Items on Preneed Contract 2. Total of Non-Guaranteed Items on Preneed Contract 7. Total of Non-Guaranteed Items on At-Need Contract 3. Percentage of Preneed Contract That Represents Non-Guaranteed Items (Divide 2 by 1) 8. Proportionate Amount of Interest to be Applied to Non-Guaranteed Items 4. Total Earnings Attributable to the Withdrawal of Funds on Preneed Contract 9. Additional Amount Due From Family or <Amount Due To Family> Section II - Non- Guaranteed Items (Add 6+8 and Subtract 7) 5. Proportionate Amount of Interest to be Applied Towards Non-Guaranteed Items (Multiply 3 and 4) 10. Section I Guaranteed Contract Totals 11. Discount Reflected on Preneed Contract 12. Subtotal from Column C. Inflation Discount 13. Other Discounts Given On At-Need 14. Subtotal for Column F. Price Adjustment When At-Need Prices are Less Than Preneed 15. Service/Merchandise Upgrade Amount 16. Service/Merchandise Downgrade <Credit Due> 17. Additional Amount Due From Family or <Amount Due To Family> Section II - Non- Guaranteed Items 19. Amount Owed on Preneed Contract (if Pre-Need Contract Not Paid-In Full) 20. Amount of Credit To Be Applied to At-Need Contract 21. Amount Owed by Family or <Refund Due to Family> 0
Page1of 4
Uploaded by DrInternetDonkey36 on coursehero.com