Complete Mae's pro forma balance sheet and the cash budget for the months of January, February,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete Mae's pro forma balance sheet and the cash budget for the months of January, February, and March only. Identify how much additional funds Mae requires (if any). When entering dollar values, omit the dollar sign. Please save your work for partial credit. The following information is in the Excel sheet, but included below for reference: Mae is considering keeping her flower business open on Sundays next year. If she does so, she hopes for an additional 10% increase in sales but will have to pay an additional $2500 in SGA (wages). Mae would like a minimum cash balance of at least $2000. She has already completed a pro forma income statement. Complete her pro forma balance sheet. Will any additional funds be needed next year and if so, how much? Additionally, prepare a month cash budget for January, February, and March. Monthly sales and materials orders are shown. Mae would like to keep at least $2000 cash on hand at all times. Additionally, she is expecting a $200 tax payment in January and a $800 interest payment also in January. Her SGA expenses are paid at $1200 every month. She is starting January with cash of $2300 and existing financing of $1250. Complete Mae's pro forma balance sheet and the cash budget for the months of January, February, and March only. Identify how much additional funds Mae requires (if any). When entering dollar values, omit the dollar sign. Please save your work for partial credit. The following information is in the Excel sheet, but included below for reference: Mae is considering keeping her flower business open on Sundays next year. If she does so, she hopes for an additional 10% increase in sales but will have to pay an additional $2500 in SGA (wages). Mae would like a minimum cash balance of at least $2000. She has already completed a pro forma income statement. Complete her pro forma balance sheet. Will any additional funds be needed next year and if so, how much? Additionally, prepare a month cash budget for January, February, and March. Monthly sales and materials orders are shown. Mae would like to keep at least $2000 cash on hand at all times. Additionally, she is expecting a $200 tax payment in January and a $800 interest payment also in January. Her SGA expenses are paid at $1200 every month. She is starting January with cash of $2300 and existing financing of $1250.
Expert Answer:
Related Book For
Fundamentals of Financial Management
ISBN: 978-0324272055
10th edition
Authors: Eugene F. Brigham, Joel F. Houston
Posted Date:
Students also viewed these finance questions
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
If the Federal Government increases taxes:What will be the effect on money demand, money supply, and interest rates? Money demand decreases, money supply is unchanged, and interest rates decrease...
-
The income statement of Munsun Company is presented Additional information: 1. Accounts receivable decreased $380,000 during the year, and inventory decreased $300,000. 2. Prepaid expenses increased...
-
In a selection structure, the structure-controlling condition is______________. a. Tested once at the beginning of the structure b. Tested once at the end of the structure c. Tested repeatedly until...
-
Reconsider the data from Problem 56. What is the capital recovery cost of Model 334A? Data from problem 56 Octavia Bakery is planning to purchase one of two ovens. The expected cash flows for each...
-
I Love My Chocolate Company makes dark chocolate and light chocolate. Both products require cocoa and sugar. The following planning information has been made available: I Love My Chocolate Company...
-
A monopoly water slide has demand of p(Q) = a - bQ, where p is the price per slide ("ride"), Q is the quantity of slides demanded, and a, b > 0. Fixed costs are F = 0 and constant marginal costs are...
-
Play the following games in the Games Fair: Three Prize Roller Word Scramble Marble Draw Ten Spinner For each Games Fair game, answer the following questions: Create the probability distribution in a...
-
Choose an E-Commerce Model you are using or will use with your running business or concept and explain why you chose that model by self-evaluating the following implementation factors: Ease to launch...
-
Answer the following also give reasons ? John and Alice lived in South Carolina as husband and wife for a sufficient period in SC that they were married under SC law. Eventually, they moved to...
-
ABC Corp has produced its first set of financial results. Ordinary shares in the company were issued at the start of the financial year at a price of $2.00 each. The par value of each ordinary share...
-
The owner of Newberry Consulting contributed $10,000 cash to the company. The company then used $5,000 cash to buy new equipment for the company. Finally, the company earned and received $1,000 in...
-
Inventory (Chapter 7) is a crucial aspect of supply chain management that has a variety of definitions and focuses on functionality to be properly maintained. The carrying costs of inventory include...
-
The case study explores design/manufacturing flaws, often involving errors or faulty assumptions during the design or manufacturing process. USAir Airlines Flight 427. Boeing Model 737-3B7. Give a...
-
Construct a logic diagram that implements an adder/subtracter. That is, the logic circuit will compute A + B or A - B depending on the value of X. Hint. Use the logic diagram of Figure 3.39 as a...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
Central City Construction Company, which is just being formed, needs $1 million of assets, and it expects to have a basic earning power ratio of 20 percent. Central City will own no securities, so...
-
The Black Hills Uranium Company is deciding whether or not it should open a strip mine, the net cost of which is $2 million. Net cash inflows are expected to be $13 million, all coming at the end of...
-
In what way does the Tax Code discourage corporations from paying high dividends to their shareholders?
-
Renaldo borrows $8,000 from his aunt today to help pay for college expenses. He agrees to repay the loan according to the following schedule, at a rate of 6 percent/year compounded annually. a. Draw...
-
Ken loans his grandson Rex $20,000 at 5.5 percent per year to help pay for executive chef schooling in Florida. Rex requires 3 years of schooling before beginning to earn a salary. He agrees to pay...
-
An investment has the following cash flow series where interest is 8 percent a. Determine the present worth of the series. b. Determine the future worth of the series at the end of year 8. c. Find...
Study smarter with the SolutionInn App