Homework: Budgeting
Instructions
Quantitative Analysis:
1. Using the data input provided (Exhibit 1), prepare LAF's master budgets in Excel. Do not hard-code numbers into the spreadsheet, except where permitted in the financing section of the cash budget.
Qualitative Analysis:
In a 2 to 3 page report, based on the results of your quantitative analysis:
o Determine a credit recommendation for Kent Bank, to lend or not. Justify your credit decision.
o Explain why the cash budget is more important to a bank than the accounting net income when determining a credit decision.
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Cash-Is-King.rar