These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 8, 2011

Cash Statements for Crafton Kennels

Crafton Kennels is a small family business that provides boarding services for pets while their owners are away. They also have grooming faculties and limited pet care services. Because of the limited size of the business, maintaining awareness of cash is much more important than dealing with accrual accounting. To assist in this, the VBA program I wrote takes all cash deposits and withdrawals from the bank statements and creates a monthly cash statement. The program also asks the user to classify each expense (withdrawal transaction). It then sums the expense totals to be provided in the statement. Additionally, it common sizes the statement, taking relevant line items and dividing it by total revenue which highlights the leading cash sources and expenses. Finally, the workbook contains a year to date tab that sums line item amounts from all existing statements, giving the business owners a feel for their performance for the current time period of the year.

No comments:

Post a Comment

Blog Archive