Individual Assignment: Guillermo Furniture Store Analysis Resources: The “Guillermo Furniture Analysis Approach” Excel file in the Course Materials forum for this class. Note: The data values change given the instructor name input in cell A3 of “Income Information” sheet in this file. To ensure that you are working with the correct numbers- the numbers you will be graded on- use the file posted in the Course Materials file and not the one posted in eResouce under the Week’s materials. Do not change the value in cell A3 in the “Income Information” tab. You have two scenarios to project 1) increase manufacturing technology 2) operate as Broker/ wholesaler. You also have the option to integrate the fire retardant finish into either of the options. In this file, a sheet has been created for each one of these two scenarios and the current year data from the “Income Information” sheet has been input for each scenario. For each scenario, verify the data, the relationships, and complete the five year forecast using the instructions at the top for sales/price/cost assumptions. For each scenario, on the Balance Sheet, you will need to allocate financing between debt and equity- the total value needed to balance the Balance Sheet equation (assets=liabilities plus equity) was added to debt as a “plug.” You will need to decide how much of this additional financing will need to be made through equity financing. For each scenario, given your allocation of Long-Term Debt and Equity to finance the needed assets, calculate WACC. For each scenario, calculate the cash flows, and then NPV of future cash flows using WACC as your discount rate. (You can use an industry average WACC until you fine tune the debt-equity mix and arrive at your own WACC. Discuss your NPV analysis and explain why you recommend one scenario over other(s) based on NPV and other analyses. We will be working on an example problem in the discussion this week….focus on stepping through the analysis…and don’t spend allot of time micro-analyzing the data.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need an answer to this or any other questions?
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will
direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.
