Advanced Problems for Spreadsheet Application

  1. Cash flow timing for accounts receivable. Zenotech Incorporated sells business software to a variety of companies. The payment for products and services varies across the Zenotech customers. In addition, as Zenotech increases its sales, it has more default customers due to the lack of screening for credit. Zenotech also uses discounts to provide customers an incentive to pay early on their accounts. Currently, it is offering 1.5%/30 or net 60 days on all accounts. Following are the projected sales per month for the coming year in thousands of dollars:

    Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. Dec.
    1,010 1,608 1,974 2,005 2,608 3,501 4,070 5,280 3,547 2,411 1,604 1,233

    • For ...

Get Financial Management: Core Concepts, Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial