CourseLover

(12)

$10/per page/Negotiable

About CourseLover

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 293 Weeks Ago, 6 Days Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Management Posted 23 Dec 2017 My Price 10.00

BADM 620 – FALL 2014 Case Study Part #2

HI,
I am having trouble finding the percentage change that must occur to the NUMERATOR value AND the DENOMINATOR value of each forecasted ratio in order to achieve the improvement required by the bank in 2014. Please see attached file with the question asked the question is on page 3 letter (d). The ratios need to be updated on the FORECASTED RATIO WORKSHEET column H and I. I have attached a pdf file with the question and excel spreadsheet.

BADM 620 – FALL 2014 Instructions For Case Study Part #2 TOTAL VALUE: 100 points DUE DATE: Friday, October 17,2014 INSTRUCTIONS: Contained in this second part of the CASE STUDY for BADM 620 is your assignment to prepare a Pro Forma Income Statement and Balance Sheet for Blue Ridge Industries for the year 2014 and its estimated 2014 stock price. You will complete all parts of this case study asked below. After you have completed these questions then you will submit your spreadsheet in Blackboard under the Case Study Part 2 listing. You will need to save this data as it will be used again for other parts of this semester’s Case Study. Blue Ridge Industries, Inc. The CEO of Blue Ridge Industries has just been told by the bank that a credit crisis is expected next year and the bank will be unable to maintain Blue Ridge Industries’ credit position it had in 2013. Therefore the Bank will impose stricter target standards on all of its customers next year. If Blue Ridge cannot meet these targets the bank will be forced to call in all of its loans and cancel its line of credit. This would bankrupt the company, so your task is to help the CEO prepare the forecasted (Pro Forma) Income Statement and Balance Sheet for Blue Ridge Industries for 2014. These Pro Forma Statements will represent the firm’s target values on these two statements for the managing the firm’s improvement in 2014. The Board of Directors has agreed that new Common Stock can be repurchased or sold as necessary to adjust common equity on the balance sheet, if necessary. Listed on the spreadsheet “ Case Study Part 2 (SPREADSHEET)(FALL 2014).xlsx” shaded in light purple are the 2012 and 2013 financial statements and important information and ratios you will need from Case Study Part #1. IMPORTANT FILE FORMAT : This assignment MUST be submitted in Excel spreadsheet format (.xls or .xlsx file extensions only). The course syllabus clearly states that three things are required for this course: Textbook, Connect Plus, and Microsoft Excel. CALCULATIONS : All calculations requested in this Case Study spreadsheet must be in cell reference format (e.g., = C32*G54) , any number values included in your cells or formulas will be counted incorrect (e.g., = 150215*G54) . However, you are allowed to enter number values into the cells for the BETTER RATIO VALUES in Step #1 . FILE SUBMISSION : You MUST be sure to submit the spreadsheet file you want me to grade for this assignment. I will grade the file you submit and I will not request another file from you. So be sure to double check that you are submitting your Microsoft Excel file that is your final and complete spreadsheet file before you hit the “SUBMIT” button. Page 1 of 6
Background image of page 1

Attachments:

Answers

CourseLover
(12)
Status NEW Posted 23 Dec 2017 03:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------

Not Rated(0)