Reference no: EM132048107
Question: Prepare a monthly cash budget for Cyrus Brown Mfg for a 9-month period March through November using the data below in excel: March - $100,000, April $275,000, May - $320,000, June - $450,000, July - $700,000, August - $700,000, Sept - $825,000, October - $500,000, November - $115,000. Collected estimates of the forecasts sates: Pymt Collection within the month sale = 25%, Pymt collection the month following sales = 55%, pymt collection the second month following sales = 20% Payment for direct mfg. costs like raw materials and labor are made during the month that follows the onein which such costs have incurred: March - $187,500, April - $206,250, May - $375,000, June - $337,500, July - $431,250, August - $640,000, Sept - $295,000, October - $425,000. Admin salaries approximate $35,000 a month, lease payments around $15,000 a month, depreciation charges $15,000 a month, a one time new plant investment for $95,000 is expected to be incurred and paid in June, income tax payments estimated to be $55,000 in June and Sept, miscellaneous cost estimated $10,000 a month Based on the cash budget findings answer these questions.
1. Will the company need outside financing?.
2. What is the minium lineof credit that CMB will need?
3. What doe you think of CBM's cash position during the budget period?
4. If you wre a bank manager, would wou want CBM as your cliet? Why or why not? Please show the calculation and formulas step by step clearer. This is the seond time I sent this question but I could not make out the calculations and formulas on the spreadsheet.
|
How do you determine what year he died
: Carbon-14 testing on the body of Otzi the Iceman showed the level of carbon-14 was at 52%. How do you determine what year he died?
|
|
Explain the changes in property and equipment
: Prepare an analysis that explains the changes in property, plant, and equipment from $6,163 at the end of fiscal 2011 to $6,903 at the end of fiscal 2012.
|
|
Find the absolute pressure of the helium gas
: The density of the surrounding air is 1.19 kg/m3. Find the absolute pressure of the helium gas.
|
|
Explain how natural selection led to flu illness in patients
: Explain how natural selection led to flu illness in patients, even though they received the flu shot.
|
|
What is the minium lineof credit that cmb will need
: Prepare a monthly cash budget for Cyrus Brown Mfg for a 9-month period March through November using the data below in excel: March - $100,000, April $275,000.
|
|
How successful has your entity been in terms of meeting
: Prepare a 10- to 12-slide presentation using a modality of your choice. Your boss asks you to prepare a presentation for new donors.
|
|
What are some sources for benchmarks of operational metrics
: What are some sources for benchmarks of the operational metrics described in this chapter?
|
|
How much total interest is paid over the life of the loan
: Prepare an amortization schedule for a three-year loan of $90,000. The interest rate is 11 percent per year, and the loan agreement calls for a principal.
|
|
How much total interest is paid over the life of the loan
: Prepare an amortization schedule for a three-year loan of $75,000. The interest rate is 10 percent per year, and the loan calls for equal annual payments.
|