Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is the expected loan balance at the end of Month 1 What is the expected loan balance at the end of Month 2 What

  1. What is the expected loan balance at the end of Month 1
  2. What is the expected loan balance at the end of Month 2
  3. What is the expected loan balance at the end of Month 3
  4. If interest is paid on the loan, what is the expected amount of the interest and when is it expected to be paid?
  5. Is the line of credit adequate?

Mr. Puffin is currently developing the cash budget for the first three months of operation as well as an investment in machinery in the 3rd month. Mr. Puffin needs assistance determining the financing needs.

Specifically, he wants to know how much to borrow or repay, including interest, each month.

The first month's beginning cash balance is expected to be $22,000.

Each month requires a minimum ending cash balance of $20,000.

The expected cash collections from revenues for months 1, 2, and 3 are $50,000, $90,000, and $70,000, respectively.

The budgeted operating costs for months 1, 2, and 3 are $60,000, $80,000, and $50,000, respectively.

These costs include budgeted depreciation expense for months 1, 2, and 3 of $5,000, $10,000 and $11,000 respectively.

The third month also includes a $100,000 cash outflow for an investment in new machinery.

Mr. Puffin has access to an $80,000 line of credit, with 10% annual interest rate.

For budgeting purposes, borrowings occur on the 1st day of the month and repayments occur as soon as possible with payment on the last day of the month.

Round interest calculations to nearest whole number.

For budgeting purposes, borrowings occur on the 1st day of the month and repayments occur as soon as possible with payment on the last day of the month.

Round interest calculations to nearest whole number.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Loss Control Auditing A Guide For Conducting Fire Safety And Security Audits

Authors: E. Scott Dunlap

1st Edition

1439828865, 978-1439828861

More Books

Students also viewed these Accounting questions

Question

7. Set team as well as individual performance goals.

Answered: 1 week ago