Advanced Problems for Spreadsheet Application

These problems are available in MyFinanceLab

  1. Cash flow forecasting. Regional Homes Construction Company has a very seasonal business that puts a high priority on cash flow management. Prepare a cash flow for the coming year by month for Regional Construction on a spreadsheet based on the following information:

    Projected Housing Starts for the Coming Year 2014

    Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sep. Oct. Nov. Dec.
    12 12 16 20 32 32 30 24 22 18 12 4
    • It takes four months to complete a house.

    • All houses are custom built, and the company receives payment the month following completion.

    The average sales price per home is $450,000. The average cost to build a home is:

    • Raw materials: 52% ...

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.