Finance

Have Finance Questions? Ask a Financial Expert Online.

Ask an Expert,
Get an Answer ASAP!

Finance

Please read the relevant parts of your textbook, which refer

Customer Question
to cash flow and financial...
Please read the relevant parts of your textbook, which refer to cash flow and financial planning.
To avoid any uncertainty regarding his business' financing needs at the time when such needs may arise, Cyrus Brown wants to develop a cash budget for his latest venture: Cyrus Brown Manufacturing (CBM). He has estimated the following sales forecast for CBM over the next 9 months:
March $100,000
April $275,000
May $320,000
June $450,000
July $700,000
August $700,000
September $825,000
October $500,000
November $115,000
He has also gathered the following collection estimates regarding the forecast sales:
Payment collection within the month of sale = 25%
Payment collection the month following sales = 55%
Payment collection the second month following sales = 20%
Payments for direct manufacturing costs like raw materials and labor are made during the month that follows the one in which such costs have been incurred. These costs are estimated as follows:
March $187,500
April $206,250
May $375,000
June $337,500
July $431,250
August $640,000
September $395,000
October $425,000
Additional financial information is as follows:
Administrative salaries will approximately amount to $35,000 a month.
Lease payments around $15,000 a month.
Depreciation charges, $15,000 a month.
A one-time new plant investment in the amount of $95,000 is expected to be incurred and paid in June.
Income tax payments estimated to be around $55,000 will be due in both June and September.
And finally, miscellaneous costs are estimated to be around $10,000 a month.
Cash on hand on March 1 will be around $50,000, and a minimum cash balance of $50,000 shall be on hand at all times.
To receive full credit on this assignment, please show all work, including formulas and calculations used to arrive at the financial values.
Group Project Guidelines
As a group, prepare a monthly cash budget for Cyrus Brown Manufacturing for the 9-month period of March through November.
Use Excel to prepare the monthly cash budget.
Based on your cash budget findings, answer the following questions:
Will the company need any outside financing?
What is the minimum line of credit that CBM will need?
What do you think of CBM's cash position during the budget period? Do you see any concerns for the company in this regard?
If you were a bank manager, would you want CBM as your client? Why or why not?
It is up to the members of the group to divide the assignment tasks evenly. You will be graded on group participation
Your submitted Group Project (150 points) must include the following:
Submitted: 2 years ago.Category: Finance
Show More
Show Less
Ask Your Own Finance Question
Answered in 25 minutes by:
8/22/2015
Financial Professional: John Mark, Accountant replied 2 years ago
John Mark
John Mark, Accountant
Category: Finance
Satisfied Customers: 842
Experience: ACCA
Verified
Hello
Welcome to Just answer. Copy and paste the link and download the solution
https://www.dropbox.com/s/rea1wud2antho9v/Cyrus%20brown.docx?dl=0
And
https://www.dropbox.com/s/itpfs3kwf0ajbxv/Cyrus%20Brown.xlsx?dl=0
Any queries let me know, else POSITIVELY RATE.
Thanx
Ask Your Own Finance Question
Financial Professional: John Mark, Accountant replied 2 years ago
If satisfied with my solution, please POSITIVELY RATE, so that i am paid for my work
Thanx
Ask Your Own Finance Question
Ask John Mark Your Own Question
John Mark
John Mark
John Mark, Accountant
Category: Finance
Satisfied Customers: 842
842 Satisfied Customers
Experience: ACCA

John Mark is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response...

T.G.WMatteson, IL

I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight.

BonnieChesnee, SC

Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation.

JohnMinneapolis, MN

Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with.

OrvilleHesperia, California

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Rakhi Vasavada

Rakhi Vasavada

Financial and Legal Consultant

2,608 satisfied customers

Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years

Megan C

Megan C

Certified Public Accountant (CPA)

2,218 satisfied customers

Licensed CPA, CFE, CMA, CGMA who teaches accounting courses at Master's Level

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

1,919 satisfied customers

More than 5000 online tutoring sessions.

JKCPA

JKCPA

CPA

844 satisfied customers

Bachelors degree and CPA with Accounting experience.

Eric

Eric

Financial Manager

559 satisfied customers

Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.

R. Klein, EA

R. Klein, EA

Accountant

480 satisfied customers

TurboTax Expert. QuickBooks Certified Pro Advisor

Dimitry K., Esq.

Dimitry K., Esq.

Attorney

332 satisfied customers

NASD Licensed Rep, 1997-2001, Business Attorney

< Previous | Next >

Related Finance Questions
Have a sub s corp rental properties fully depreciated wish
Have a sub s corp rental properties fully depreciated wish to do a joint venture not a sale or transfer of property.. How can this be done without triggering capital gains? … read more
LEV
LEV
Retired
Bachelor's Degree
14,896 satisfied customers
I have some questions about Residential Rental Depreciation.
I have some questions about Residential Rental Depreciation. I rented out a house in 1986 for a few years using the Acrs method of depreciation. Took the rental out of service after a few years. Now, … read more
TaxRobin
TaxRobin
Vocational, Technical or Trade School
1 satisfied customers
Lane, I'm depreciating a vehicle for "its first time" and
Hey Lane,I'm depreciating a vehicle for "its first time" and taking the Special Depreciation Bonus. My questions is during the same tax year of the S.D.B. can I also deduct the "Current Depreciation"?… read more
NPVAdvisor
NPVAdvisor
CFP Licensee and Practitioner
Master's Degree
180 satisfied customers
Can I take depreciation on my investment property without
Can I take depreciation on my investment property without selling it … read more
Barbara
Barbara
Enrolled Agent, Paralegal
3,490 satisfied customers
4 years into 5 year depreciation, contractor who was using
4 years into 5 year depreciation, contractor who was using computer equipment my C corp owned went out of business and lost the equipment to his landlord. I'm guessing I can write off the balance, but… read more
PDtax
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Double declining balance depreciation. Shouldn't the asset
Double declining balance depreciation. Shouldn't the asset be fully depreciated after the useful live if there is no salvage value? If this calculator is wrong, please provide a schedule that is corre… read more
ABC Accounting Group
ABC Accounting Group
Bachelor\u0027s Degree
682 satisfied customers
Depreciation of legal and architect and engineer fees for a
Depreciation of legal and architect and engineer fees for a commercial real estate property. Is it a capital improvement of 39 years and can it be bonus/accelerated ? … read more
Matthew Breecher
Matthew Breecher
President
MBA (Graduate Legal Studies)
285 satisfied customers
I am going to sell a rental property. I have depreciated it
I am going to sell a rental property. I have depreciated it $14,000. I am retired...what will my tax problems be? … read more
ABC Accounting Group
ABC Accounting Group
Bachelor\u0027s Degree
682 satisfied customers
I need to depreciate a a/c machine for a car shop, what is
I need to depreciate a a/c machine for a car shop , what is the life of the machine? I also need to depreciate a lift for a car shop . What is the estimated life of the equipment? Thanks… read more
Anne
Anne
Master Tax Preparer
1,328 satisfied customers
Can one take a "bonus depreciation" (50% depreciation in the
Hello, can one take a "bonus depreciation" (50% depreciation in the first year of service) on capital improvements done to a residential rental property? This is for the 2013 tax return.… read more
NPVAdvisor
NPVAdvisor
CFP Licensee and Practitioner
Master's Degree
180 satisfied customers
How do I correctly make an entry for depreciation of
How do I correctly make an entry for depreciation of computer and office equipment (using software system Xero)? If the equipment was purchased in 2015, does the depreciation get recorded on Dec 31, 2… read more
ABC Accounting Group
ABC Accounting Group
Bachelor\u0027s Degree
682 satisfied customers
I have a question regarding stepped up depreciation and
I have a question regarding stepped up depreciation and being a real estate professional. … read more
keeperumiami
keeperumiami
Sr Financial & Tax Consultant
Bachelor\u0027s Degree
1 satisfied customers
When you are taking depreciation section 179 for new
When you are taking depreciation section 179 for new furniture, can you use 7 years for the life?… read more
LEV
LEV
Retired
Bachelor's Degree
14,896 satisfied customers
Can I have depreciation section 179 for new furniture that
Can I have depreciation section 179 for new furniture that cost me $700 on the form the 1120s?… read more
Mark Taylor
Mark Taylor
Certified Public Accountant
Masters
2,230 satisfied customers
Calculate car depreciation for my s corp My accountant says
Calculate car depreciation for my s corp My accountant says there is car depreciate limit defined by IRS. Acct uses 200 DB Hy calculation but restricted by annual irs limit for car. I need to how amou… read more
keeperumiami
keeperumiami
Sr Financial & Tax Consultant
Bachelor\u0027s Degree
1 satisfied customers
2015 adjusting entries/depreciation for your or your CPA.
2015 adjusting entries/depreciation for your or your CPA. Our LLC account just sent me this email and I have no ideal what she is talking about. … read more
Mark Taylor
Mark Taylor
Certified Public Accountant
Masters
2,230 satisfied customers
Sole proprietorship- if you sell a fully depreciated asset,
Sole proprietorship- if you sell a fully depreciated asset, does that money show up as income ? If so, where ? … read more
Mark Taylor
Mark Taylor
Certified Public Accountant
Masters
2,230 satisfied customers
Question .- if i want to do depreciation on a rental
question .- if i want to do depreciation on a rental property do i need to enter section 179 limit and how much it is ?also the property was purchased on 08/01/2016please advise… read more
Mark Taylor
Mark Taylor
Certified Public Accountant
Masters
2,230 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x