Prepare a memo for Claire setting out your thoughts on the cash-flow situation. Pay particular attention to the interest requirements. The memo should include the following: • A Cash Flow Analysis prepared per the monthly requirements [Show your work through a comprehensive spreadsheet of expenditures, interest payments, and inflow draw amounts] o HINT: INTEREST ON THE LOAN IS DUE THE MONTH AFTER THE DRAW, AND EVERY MONTH AFTER THAT. • An explanation of why a cash flow analysis is important to an owner and why a bank would want a record of this while applying for a loan • A list of the Project Months when Claire will have to make each draw. • The total cost of interest due to Claire each month and in total for the whole project time. Do the numbers match with Corny's estimate on allowance? Do your findings change your earlier recommendation to Claire about whether the project is a sound investment?