Question: Write a user-defined function that calculates the average collection period with two arguments: accounts receivable and annual credit sales, and assumes that there are 360

Write a user-defined function that calculates the average collection period with two arguments: accounts receivable and annual credit sales, and assumes that there are 360 days per year.
Now, write another version of the function that accepts an optional third argument that indicates whether to use 360 or 365 days in a year. This third argument should default to using a 360-day year. The second function should return an error value (look up CVErr in the help) if the user specifies any number other than 360 or 365 days per year.

Step by Step Solution

3.42 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 00... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

624-B-A-F-A (2221).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!