Prepare a combined cash budget for Marcel Company for January, February, and March. Note the following:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prepare a combined cash budget for Marcel Company for January, February, and March. Note the following: . Cash collections were $8,960 in January, $12,080 in February, and $11,340 in March. Cash payments were $11,240 in January, $11,000 in February, and $11,500 in March. Marcel's beginning cash balance is $5,000, and Marcel desires to maintain a minimum ending cash balance of $5,000. ● Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The company did not have any outstanding borrowings on January 1. ● The interest rate on amounts borrowed is 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Round interest expense to the nearest whole dollar. Marcel Company Cash Budget For the Three Months Ended March 31 January February Total Beginning cash balance Plus: Cash collections Total cash available Less: Cash payments Ending cash available before financing Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments Ending cash balance March Prepare a combined cash budget for Marcel Company for January, February, and March. Note the following: . Cash collections were $8,960 in January, $12,080 in February, and $11,340 in March. Cash payments were $11,240 in January, $11,000 in February, and $11,500 in March. Marcel's beginning cash balance is $5,000, and Marcel desires to maintain a minimum ending cash balance of $5,000. ● Marcel borrows cash as needed at the beginning of each month in increments of $1,000 and repays the amounts borrowed in increments of $1,000 at the beginning of months when excess cash is available. The company did not have any outstanding borrowings on January 1. ● The interest rate on amounts borrowed is 8% per year. Interest is paid at the beginning of the month on the outstanding balance from the previous month. Round interest expense to the nearest whole dollar. Marcel Company Cash Budget For the Three Months Ended March 31 January February Total Beginning cash balance Plus: Cash collections Total cash available Less: Cash payments Ending cash available before financing Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments Ending cash balance March
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Given that the firm did not have any problem paying the higher bill, would Nathan's planned course of action be ethical? Why or why not?
-
Marcel owns 12 percent of Steam Forge Company (SFC). SFC trades on the Toronto Stock Exchange and has been the subject of a takeover attempt by Iron Forge Company (IFC). Assuming that Marcel is the...
-
6. On January 1, Puckett Company paid $1.6 million for 50,000 shares of Harrison's voting com- mon stock, which represents a 40 percent investment. No allocation to goodwill or other spe- cific...
-
A project is proposed to design a database for shops selling dairy products. Each shop has a unique ID, name, address and owner. Different shops could be owned by the same owner. Each shop sells...
-
A business borrows $1,000, giving a note that requires repayment of the amount borrowed in two payments of $600 each, one at the end of each of the next two six-month periods. Calculate the total...
-
In about 200 words, outline the reasons why a consumer who owns a credit card would want to use an electronic payment system, such as PayPal, for an Internet transaction. In an additional 200 words,...
-
Percentage of Credit Sales Method} Ruby Red manufactures, markets, and distributes citrus-flavoured soft drinks across the globe. Ruby Red hired a collection agency in 2017 to increase collection...
-
1. Develop forecasts using regressions of sales on each of the series of rain forecasts respectively. Calculate the MFE (bias), MAD, and MAPE for the two forecasting models. Which rain forecast seems...
-
A firm has the following book-value balance sheet; Debt =$ 14 ,000, Common Stock ($1 par)= 11 and Retained Earnings = $ 23 ,000. The book value of assets is the total of Debt, Common Stock and...
-
Bob purchased a property for $6,500,000 at a 5.50% cap rate. At the time of purchase, there were 15 years remaining on the lease with 7.50% rent increases every 5 years. Bob purchased the above...
-
Skylar and Walter Black have been married for 25 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Skylar is a stay-at-home parent and Walter is a high school teacher. His...
-
In Milestone One, you analyzed the brand implications of reopening the park, and you have delivered the analysis in the form of a written report. In your role as regional marketing director of one of...
-
a. Given: The mechanical energy equation for a particular device known as a Koch flow cell can be written as: 2 2 Pi - Pi+1 + 4mi - 6mi+1 = 0 The nonlinear portions (the mass flow rates squared), can...
-
Why must a product design be developed prior to a process plan? (LO3.1)
-
Why is it important to have an ethical organization? What benefits are there to having an ethical organization? What happens to the organization when individuals within the company act unethically?...
-
3. A disk is driven by a motor such that it has an angular velocity defined by w = 4t + 3t rad/s, where t is in seconds. At t = 0, 0 = 0. Determine the angular displacement, velocity, and...
-
1 0 1 2 3 4 5 1 2 V 3 4 4 3 L D 5
-
Heineken N.V., a global brewer based in the Netherlands, reports the following balance sheet accounts for the year ended December 31, 2016 (euros in millions). Prepare the balance sheet for this...
-
Last month, Talley Corporation purchased and used the same quantity of material in producing its product, speed bumps for traffic control. Complete the following table. Direct materials information...
-
Refer to Oleg's Steel Parts in E7-46B. Oleg feels like he's in a giant squeeze play: The automotive manufacturers are demanding lower prices, and the steel producers have increased raw material...
-
Refer to the Popping Bubbles' data in P10-49B. The company sold 70,000 bubble kits during March and its actual operating income was as follows: Data in P10-49B Requirements 1. Prepare an income...
-
Can you think of any drawbacks in providing interim financial statements for users? R3
-
A year ago Pod Limited bought 225,000 1 fully paid ordinary shares of Pea Limited for a consideration of 500,000. Pea Limiteds share capital and share premium were each the same as at todays date....
-
Segmental information relating to Dali pic for the year to 31 December 2012 is shown below. Required: Analyse the performance of each of the three main business segments for the year and comment on...
Study smarter with the SolutionInn App