please answer in excel

Jennifer's Wedding Boutiques eamed net income of $78,000, which included depreciation of $13.000 Jennifer's acquired a $116,000 building by borrowing $116,000 on a long-term note payable. Requirements 1. How much did Jennifer's cash balance increase or decrease during the year? 2. Were there any non-cash transactions for the company? If so, show how they would be reported in the statement of cash flows. Requirement 1. How much did Jennifer's cash balance increase or decrease during the year? Complete the following table to calculate Jennifer's cash balance, and indicate whether this balance represents an increase or a decrease in cash. (Enter a "o for any item(s) that do not affect cash.) Net income Depreciation Expense Purchase of building with a long-term note in cash Requirement 2. Were there any non-cash transactions for the company? If so, show how they would be reported in the statement of cash flows. Were there any non-cash transactions for the company? Show how they would be reported in the statement of cash flows