A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The quarterly interest rate is 2%, and any borrowing and repayment of principal must be in round $1,000 amounts. There is no cash reserve requirement. Assume loan related payments are made when excess cash is available. Excess (deficiency) of cash available over disbursements Quarter 1 2 3 4 Year $ (121,140) $(41,680) $177,680 $2,160 $17,020 Required: 1. Prepare a cash budget by quarter and for the year. (Any "Repayments", "Interest" and "Deficiency of cash" should be indicated by a minus sign.) Cash balance, beginning Cash Budget 1 Quarter 3 Year Excess (deficiency) of cash available over disbursements Balance available for repayment (required borrowing) $ 0 $ 0 $ 0 $ 0 $ 0 Financing: Amount borrowed (beginning of period) Principal repaid Interest paid Total financing (or repayments for the period) $ 0 $ 0 $ 0 $ Cash balance, ending 2. What is the ending cash balance in the fourth quarter if interest is accrued until the end of the fourth quarter and paid at that time along with the the total principal borrowed? Ending cash balance A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The quarterly interest rate is 2%, and any borrowing and repayment of principal must be in round $1,000 amounts. There is no cash reserve requirement. Assume loan related payments are made when excess cash is available. Excess (deficiency) of cash available over disbursements Quarter 1 2 3 4 Year $ (121,140) $(41,680) $177,680 $2,160 $17,020 Required: 1. Prepare a cash budget by quarter and for the year. (Any "Repayments", "Interest" and "Deficiency of cash" should be indicated by a minus sign.) Cash balance, beginning Cash Budget 1 Quarter 3 Year Excess (deficiency) of cash available over disbursements Balance available for repayment (required borrowing) $ 0 $ 0 $ 0 $ 0 $ 0 Financing: Amount borrowed (beginning of period) Principal repaid Interest paid Total financing (or repayments for the period) $ 0 $ 0 $ 0 $ Cash balance, ending 2. What is the ending cash balance in the fourth quarter if interest is accrued until the end of the fourth quarter and paid at that time along with the the total principal borrowed? Ending cash balance
Expert Answer:
Answer rating: 100% (QA)
1 Prepare a cash budget by quarter and for the year Cash Budget Quarter 1 2 3 4 Y... View the full answer
Posted Date:
Students also viewed these accounting questions
-
This is for a finance class: 1 ) In 3 to 4 sentences, explain the determination of the firm s optimal capital structure. 2 ) In 3 to 4 sentences, explain how corporations decide whether to pay stock...
-
A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The...
-
A company has the following excess (deficiency) of cash receipts over cash disbursements projected for the next year on a quarterly basis. It will not have any cash at the start of the year. The...
-
An abc-sequence set of voltages feeds a balanced three-phase wye-wye system. The line and load impedances are and , respectively. If the load voltage on the a phase is , determine the voltages at the...
-
Dan Partridge is a risk averter who tries to maximize the expected value of c, where c is his wealth. Dan has $50,000 in safe assets and he also owns a house that is located in an area where there...
-
Rebecca is a doctor with an AGI of $125,000 before consideration of income or loss from her dog breeding business. Her home is on 15 acres, 10 of which she uses to house the animals and provide them...
-
If you heard from an employee of a local bank that its a tradition here for us to stand up and defend the bank when someone criticizes it, you could assume that the bank employees had strong...
-
ANALYSIS OF PROFITABILITY Based on the financial statement data in Exercise 24-1B, compute the following profitability measures for 20-2 (round all calculations to two decimal places): (a) Profit...
-
ABC Inc. is evaluating a new project requiring an initial outlay of $900,000. The project will generate the following cash flows: Year 1: $160,000 Year 2: $170,000 Year 3: $180,000 Year 4: $190,000...
-
.17X F Lam set up a firm on 1 April 2022. He contributed to the firm some furniture from his home valued at $30,000. The firm took out a bank loan of $100,000 for business operations and purchased...
-
Read David Dunwood 1. Consider Dunwood's handling of the board's severance matter. How could he have prevented the challenging situation he faced? 2. Assuming Dunwood and the board have agreed on a...
-
Want to give someone a life changing compliment? This is an amazing opportunity for a manager who has a high level of emotional intelligence and can influence motivation. Check out this article for...
-
A, B, C, and D represent the population of four towns in terms of t, the number of years since 2000. A = 600 (1.12) B = 1000(1.03) a. Which of the towns is experiencing a decline in population? C =...
-
Jada (age 53) and Elijah (age 60) are married, and both are self-employed. In 2023, they participate in a health insurance plan with a $3,000 annual deductible and out-of-pocket maximum of $9,000....
-
Part A) Ang Myat is a 32-year-old man who is originally from Myanmar and lived on the Thai-Burma border in a refugee camp since he was a teenager. He is accompanied by his friend Denpo for support....
-
the most important equitable remedy is an which is a court order forbiding a party to do some act or commanding her to perform some act
-
Suppose the government bond described in problem 1 above is held for five years and then the savings institution acquiring the bond decides to sell it at a price of $940. Can you figure out the...
-
In 1969, William Kling, then age 26, was managing a radio station at St. John's Abbey and University in Minnesota. He hired a young man named Garrison Keillor to host a classical music program in the...
-
Founded in 1997 in Washington, DC, by social entrepreneurs Rajiv Vinnakota and Eric Adler, the SEED Foundation operates urban, college-preparatory, public boarding schools in Washington, DC,...
-
Go back and read the case of Aspire CoffeeWorks in Chapter
Study smarter with the SolutionInn App