Blue Ridge Industries, Inc. Case Study Assingment Help With Solution
In the three preceding case studies, you have evaluated the firm’s financial condition, evaluated expansion proposals, and prepared a forecast of what the firm must do in 2014 to comply with the bank’s benchmark requirements.Now, the CEO of Blue Ridge Industrieswants to be able to present to the Board of Directors the following items:
1. Based on the major changes planned for 2014 the CEO would like to report to the board the changes in the firm’s Operating Cycle and Cash Cycle from 2013 to 2014.
2. An evaluation of a bank proposed Lockbox system that should speed up the collection of Accounts Receivable.
3. An evaluation and recommendation of Blue Ridge Industries major supplier’s new credit terms for 2014.
How it Works
How It works ?
Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention product code mentioned in end of every Q&A Page. You can also send us your details through our email id email@example.com with product code in the email body. Product code is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.
Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to product code . The date is asked to provide deadline.
Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id firstname.lastname@example.org and email@example.com must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.
Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.
Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.
Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.
Features for Assignment Help
We believe in providing no plagiarism work to the students. All are our works are unique and we provide Free Plagiarism report too on requests.
We believe in providing perfect, relevant and 100% accurate solutions to the student as per questions asked. All our experts are perfect in providing that so as to give unique experience to the students.
We are the only service providers boasting of providing original, relevant and accurate solutions. Our three stage quality process help students to get perfect solutions.
All our works are kept as confidential as we respect the integrity and privacy of our clients.
- Physics Assignment Help
- Chemistry Assignment Help
- Engineering Assignment Help
- Psychology Assignment Help
- Online exam Help
- Marketing Assignment Help
- Arts Assignment Help
- Sociology Assignment Help
- Project Management Assignment
- Case Study Help
- Nursing Assignment Help
- Research Assignment Help
- Operations Management Assignment help
- Accounting Assignment Help
- Biology Assignment Help
- Mathematics Assignment Help
- English Assignment Help
- Business Plan Help
- Essay Writing Help
- Human Resource Assignment Help
- Accounting Homework Help
- Computer Science Assignment Help
- Finance Assignment Help
- Economics Assignment Help
- Statistics Homework Help
- Management Assignment Help
- Strategy Management Assignment Help
- Auditing Assignment Help
- Information Management Assignment Help
- Online Assignment Writing help
- Best Assignment Help
- Humanities Assignment help
- Corporate Finance Assignment help
- Financial Management Assignment Help
- Supply Chain Management Assignment Help
- Taxation Homework Help
- MBA operations management assignment help
- History Assignment help
- Geography Assignment Help
- Anthropology Assignment help
- Archaeology Assignment help
- Counselling assignment help
- Criminology assignment help
- Linguistics Assignment Help
- Architecture Assignment Help
- Philosophy Assignment Help
- Physics and Astronomy Assignment Help
- Physiotherapy Assignment Help
- Politics Assignment Help
REQUIRED ANALYSIS FOR CASE STUDY PART #4:
A. Operating Cycle and Cash Cycle for 2013 and 2014: Since the firm expects to make some major improvements in asset control in 2014, the CEO wants you to calculate the following:Enter your calculation on the spreadsheet labeled OPERATING & CASH CYCLES. (These calculations are similar to Chapter 26 Practice Problem 26-6. Remember to use average account balances in these calculations as instructed to do in your textbook.)
1. Inventory period for 2013versus2014
2. Receivables period for 2013versus2014.
3. Operating Cycle for 2013versus2014
4. Payables period for 2013versus2014
5. Cash Cycle for 2013versus2014
6. Assuming the Operating Cycle and the Cash Cycles improved in 2014; explain what SPECIFIC benefits the firm would expect to receive as a result of these improvements. (This is a theoretical question. Answer the question as asked regardless of the actual changes in the Operating and Cash Cycles of this case study.)
B. Evaluation of the Lockbox System: The bank has proposed a new lockbox system for Blue Ridge Industries that should speed up the collection of Accounts Receivable and improve the firm’s cash flow in 2014. The CEO wants you to prepare an analysis of the benefits and cost of the Lockbox proposal and make a recommendation about whether the firm should adopt the Lockbox system or not. Enter your calculation on the spreadsheet labeled LOCKBOX PROPOSAL.(These calculations are similar to Chapter 27 Practice Problem 27-8))
Lockbox Proposal:Based onits receivables history,Blue Ridge Industries found it takes about 9 days to receive and deposit checks from its customers. Blue Ridge Industries’ management is considering a lockbox system to reduce the firm’s collection times. It is expected that the lockbox system will reduce receipt and deposit times to 3 days total. The required rate of return for this project will bethe firm’s 2014WACC (%)provided for you in the PREVIOUS CASE STUDY DATA.You will need to determine the Average Daily Collections for Blue Ridge Industriesbased on the formula:
Average Daily Collections2014 = Accounts Receivable2014 / Receivables Period2014
The questions that the CEO needs you to answer are as follows:
1. What is the reduction in Uncollected Accounts Receivable as a result of implementing the lockbox system?(Remember, uncollected accounts receivable = outstanding cash balances.)
2. What is the maximum monthly charge Blue Ridge Industries should pay for this lockbox system if the payment is made at the END of every month?
3. If the bank plans to charge a fee of $20,750 at the end of every month; is the lockbox service acceptable? Explain your answer.
4. Assuming the lockbox service is acceptable, what impact would this service have on a firm’s Cash balances and Account Receivable balances? (This is a theoretical question. Answer this question as asked regardless of whether you thought the lockbox service is acceptable or not.).
5. Calculate the changes to the firm’s 2014 Operating Cycle in the table provided in the spreadsheet based on accepting the lockbox service. Fill in the cells highlighted in YELLOWin the table provided on the LOCKBOX PROPOSAL worksheet.
Shown below are instructions for calculating the change in the firm’s 2014 Operating Cycle if the lockbox is accepted:
STEP 1. Determine Accounts Receivable 2014(With Lockbox):
= Accounts Receivable 2014(Without Lockbox) – Reduction in Accounts Receivable(With Lockbox)
STEP 2. Determine Average Accounts Receivable(With Lockbox):
= [Accounts Receivable 2013 + Accounts Receivable 2014(With Lockbox)] / 2
STEP 3. Determine Receivable Period 2014(With Lockbox):
= 365 days / (Sales 2014 / Average Accounts Receivable(With Lockbox))
STEP 4. Determine Operating Cycle 2014(With Lockbox):
= Inventory Period 2014 + Receivable Period 2014(With Lockbox)
STEP 5. Determine Difference in Operating Cycle 2014(With Lockbox):
= Operating Cycle 2014(Without Lockbox) − Operating Cycle 2014(With Lockbox):
C. Evaluation of the New Credit Terms: ACME Supply Company, Blue Ridge Industries’ largest supplier, has offered Blue Ridge Industries some radically new credit terms for 2014. ACME Supply is offering credit terms of 1%/10, net 45, which means that if the firm pays its ACME Supply invoices in 10 days it can deduct 1.0% from the invoice total, however, if it does not pay in 10 days then the firm will have to pay the entire amount of the invoice in 45 days. If Blue Ridge Industries pays ACME Supply in 10 days and takes the 1.0% discount the firm will have to borrow from the bank using Notes Payable and the CEO knows that the current interest cost on Notes Payable is 8.0%. He would like to be able to take the 1.0% discount but only if it makes financial sense.So the CEO wants you to answer the following questions:Enter your calculation on the spreadsheet labeled CREDIT POLICY EVALUATION. (These calculations are similar to Chapter28Practice Problem 28-5)
1. What is the effective annual interest rate the firm would be paying if it DOES NOT take the 1% discount and chooses to pay in 45 days (opportunity cost)?
2. Given that the interest rate on Notes Payable is 8.0%, make a recommendation to the CEO as to whether Blue Ridge Industries SHOULD or SHOULD NOT take the 1% discount.Be sure to explain your recommendation.
3. Assuming Blue Ridge Industries does take the 1% discount and pays invoices in 10 days, how would the firm’s Accounts Payable and Notes Payable account balances change. Tell me if these two accounts would INCREASE or DECREASE (REGARDLESS of what you recommended above) and EXPLAIN WHY.
4. Assuming Blue Ridge Industries does take the 1% discount and pays invoices in 10 days, what changes in the firm’s 2014 Operating Cycle and Cash Cycle would you expect (REGARDLESS of what you recommended above)? EXPLAIN YOUR ANSWER.
D. Complete all of your calculations in the Excel spreadsheet named “Case Study Part #4 (SPREADSHEET)(FALL 2014).xlsx”. Each part of the assignment has its own worksheet and I left the worksheet unprotected so you can develop your own formulas. However, you MUST put the required answers in the specific cells highlighted in YELLOW on every worksheet in order to get credit for your work.
E. When you have completed all parts of this assignment in the worksheet “Case Study Part #4 (SPREADSHEET)(FALL 2014).xlsx” submit the entire spreadsheet in Blackboard under the Case Study Part #4 heading. Your file MUST be file type .xls or .xlsx, no other file types will be graded.
1. It would be helpful if you would include your name in the filename of your submitted Case Study Part #4spreadsheet. For example: Your filename would be:
CASE STUDY PART 4 – Your First and Last Name Here.xlsx
Product Code :Case107
To get answer for this question, kindly click here (Note: Don’t forget to write the product code in comment section)
You can also email us at firstname.lastname@example.org but please mentioned product code in the mail body while sending emails.You can browse more questions to get answer in our Q&A sections here.