HW3 spring 2020 (1) Mailings Review View Help Table Design Layout Cash Flow Budgeting Use the following information to prepare a quarterly cash flow budget. (A budget form is provided on the next page.) Qx indicates the quarter in which the revenue or expense will occur. (67pts) Read this before placing items in the CFB: There is no current operating debt at the start of the year. Current debt may be incurred to cover any cash deficits. Excess cash may be used to pay down debt if any), Ignore interest costs on current debt. Make payments on current debt from last quarter in the very next quarter. Remember for the summary of debt outstanding to make the adjustment in Q4 for letter b). Also remember that cash inflow is the (beginning cash balance + all cash inflows). (The totals column counts for points as well) a) Beginning cash balance - $4250 b) Farm mortgage payments - $50,000 (24) hint: non-current princ. c) Grain sales -$61,000 (Q1), $79,000 (03) and $28,000 (24) d) Crop expenses - $50,000 (Q2), $10,000 (03), $8,000 (24) hint: it is now e) Family living expenses - $13,000 (each quarter) f) Off-farm income-$4,000 (each quarter) g) new equipment purchase-$12,000 (21) h) new long-term borrowing-$8,000 (Q1) hint: noncurrent i) minimum ending cash balance - $3,000 (each quarter) i) Beginning mortgage balance is $300,000. hint: noncurrent in summary other new noncurrent Body HW) spring 2020 (1) Layout References Mailings Review View Help Table Design Layout Beric h Balance Operating Expenses DOLL HW spring 2020 (1) Search Family Living expenses Noncurrent del principal Nereden Total cash outflow Net Cash Flow New Borrowing Total New Borrowing Payments on New Current Total debt payments Ending Cash Balance Summary of debt Outstanding Total Debt Outstanding DELL HW spring 2020 resign Layout References Mailings Review viow Help Table Design Layout Economic Principles Production levels Complete the following table and use the fact column to make a decin about how mailing output le ts) to reduce (Produce out Natrogen Y bushes) prod M (IP h ) p product MEP reven Com 100 RO What is the expected at the pri c e DELL HW3 spring 2020 (1) Mailings Review View Help Table Design Layout Cash Flow Budgeting Use the following information to prepare a quarterly cash flow budget. (A budget form is provided on the next page.) Qx indicates the quarter in which the revenue or expense will occur. (67pts) Read this before placing items in the CFB: There is no current operating debt at the start of the year. Current debt may be incurred to cover any cash deficits. Excess cash may be used to pay down debt if any), Ignore interest costs on current debt. Make payments on current debt from last quarter in the very next quarter. Remember for the summary of debt outstanding to make the adjustment in Q4 for letter b). Also remember that cash inflow is the (beginning cash balance + all cash inflows). (The totals column counts for points as well) a) Beginning cash balance - $4250 b) Farm mortgage payments - $50,000 (24) hint: non-current princ. c) Grain sales -$61,000 (Q1), $79,000 (03) and $28,000 (24) d) Crop expenses - $50,000 (Q2), $10,000 (03), $8,000 (24) hint: it is now e) Family living expenses - $13,000 (each quarter) f) Off-farm income-$4,000 (each quarter) g) new equipment purchase-$12,000 (21) h) new long-term borrowing-$8,000 (Q1) hint: noncurrent i) minimum ending cash balance - $3,000 (each quarter) i) Beginning mortgage balance is $300,000. hint: noncurrent in summary other new noncurrent Body HW) spring 2020 (1) Layout References Mailings Review View Help Table Design Layout Beric h Balance Operating Expenses DOLL HW spring 2020 (1) Search Family Living expenses Noncurrent del principal Nereden Total cash outflow Net Cash Flow New Borrowing Total New Borrowing Payments on New Current Total debt payments Ending Cash Balance Summary of debt Outstanding Total Debt Outstanding DELL HW spring 2020 resign Layout References Mailings Review viow Help Table Design Layout Economic Principles Production levels Complete the following table and use the fact column to make a decin about how mailing output le ts) to reduce (Produce out Natrogen Y bushes) prod M (IP h ) p product MEP reven Com 100 RO What is the expected at the pri c e DELL
