'Insurances for Homes' company provide home insurance service. They have in-house built system that processes home insurance payments received from customers. The end result of the process consists of a listing of individual journal entries in a spreadsheet. They have requirements for getting all journal entries in a secure and auditable repository. Access will be limited to selective staff members. Additionally, be able to report and view the entries using an advanced reporting and analytical tools forslicing and dicing the Journal entries.
Which is a correct example for a formula to prorate amounts evenly across each period? Note that the NumberofGLPeriod is a predefined function that returns the number of non adjustment accounting periods between twodates.