Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Print it Green, Inc. is a manufacturer of recycled printing supplies. The company began operations on 10/1/2008 and is dedicated to producing sustainable green printing products. Print it Green, Inc. provides recycled laser toner cartridges, recycled ink jet cartridges as well as cases of recycled copy paper to a variety of customers across the United States.

Upper management created several detailed sales forecasts for FY 2010. Now that Print it Green, Inc. is beginning the final quarter of their year, management has requested that a detailed analysis be performed as to whether the company is expected to achieve the forecasted results.

Print it Green's Sales Manager has pulled together the detailed sales forecasts for FY 2010 as well as the inception¬to-date sales data from their accounting system (see the additional tabs below). She has requested that an Excel Dashboard be created to illustrate on a detailed basis whether or not the company is expected to achieve total forecasted sales of $1,006,000 for FY 2010.

Using at least three of the Excel functions and/or capabilities that we have learned in class, create an Excel Dashboard that will address the Sales Manager's request for Print it Green, Inc.

create a good Dashboard for this assignment. The functions that should be used are the TREND function, VLOOKUP, IF, HLOOKUP, Carts and Pivot Tables. I will tip very generously if the assignment is not simply copied and pasted from another source.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91905513

Have any Question?


Related Questions in Basic Finance

Demetrius wants to buy a 1000 face value bond that

Demetrius wants to buy a $1,000 face value bond that currently has a yield to maturity of 8.61 percent. The bond matures in 5 years and pays interest annually. The coupon rate is 8.5 percent. What is the current price of ...

Question - your firm is contemplating the purchase of a new

Question - Your firm is contemplating the purchase of a new $670,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $50,000 at the end of ...

A company recently had 26 million shares outstanding

A company recently had 26 million shares outstanding trading at $45/share. The company announces its intention to raise $290M by selling new shares. Studies show losses are 30%of the size of the new issue, so how large a ...

Please show the steps to work out this problem along with

Please show the steps to work out this problem along with the answer. Thank you. What is the accumulated sum of the following stream of payments? $2,747 every year at the end of the year for 4 years at 5.01 percent, comp ...

Consider the following two mutually exclusive

Consider the following two mutually exclusive projects: Project / Year 0 1 2 3 4 Cost of Capital A -100 40 40 40 40 15% B -73 30 30 30 30 15% Which of the following is closest to the incremental IRR?

1nbsphow do the geometric and arithmetic average dividend

1. How do the geometric and arithmetic average dividend growth rates compare when the annual growth rates are positive? A. The arithmetic average dividend growth rate is generally larger than the geometric average growth ...

Express surgerys preferred stock which has a par value

Express Surgery's preferred stock, which has a par value equal to $110 per share, pays an annual dividend equal to 9% of the par value. If investors require a 15% return, what's the stock's market value?

Question - cannonier inc has identified an investment

Question - Cannonier, Inc., has identified an investment project with the following cash flows. Year Cash Flow 1 $970 2 1,200 3 1,420 4 2,160 If the discount rate is 7 percent, what is the future value of these cash flow ...

Why would a person research the effects of global

Why would a person research the Effects of global competitiveness on strategic human resources?

A firm has 21000000 of available retained earnings the

A firm has $21,000,000 of available retained earnings. The capital structure is 48% debt, 8% preferred equity and 44% common equity. At what point in total funding will the company exhaust its available retained earnings ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As