Learning Plan 3 Assessment - Essay Example

Only on StudentShare

Extract of sample
Learning Plan 3 Assessment

Let’s say you are considering the purchase of a new car and you want to see how the interest rate impacts your monthly payment. The car is priced at $ 20,000, you want to finance it for five years (60 months), and the dealer is making an initial offer to you at a rate of 6% while your bank will loan you the money for 4.7%. Then, as you negotiate your deal with the car sales manager, you discover that the manufacturer is offering a rate of 2.2% if you buy the car in the next three days. As demonstrated in the chart below, the interest rate impacts the amount of money you will pay each month:
The row labeled interest rate is the value that is changed in Goal seek. After setting the formula to calculate monthly payments for the parameters described above, simply click on Tools, Goal Seek. Excel will provide a pop-up window to allow you to determine which field is to be affected by your what-if scenario. In the “set cell” field, simply click on the cell that has the payment amount in it. Skip over the “To value” section and click in the “By changing cell.” At that point, click on the cell that has the interest rate variable and click “okay.” You will then be able to change the interest rate and, each time you do so, the payment will change to show you the payment associated with the altered interest rate. In the table above, the three possible interest rates offered by the dealership, bank, and manufacturer are shown, and the corresponding payments indicate the difference the rates make. It is intuitive that the lower the interest rate the lower the payment, but the Goal Seek tool allows you to see that there is a difference of over $ 30.00 per month between the rates offered. This is just a simple example of what Goal Seek can do, and the models used by most business analysts are much more complicated than the one shown here. The advantage of Goal Seek is that it allows the ...
Download paper


Goal Seek is “part of a suite of commands sometimes called what-if analysis…a process of changing the values in cells to see how those…
Author : boscoboyd

Related Essays

Quality Assessment Plan
We set out a methodology of assessment within a plan that also includes documentation of where our trainers are meeting the standards, and where this is not happening. This gives us information on how we might improve our trainers' performance, after which we would refine the assessment method and repeat the process....
15 pages (3765 words) Assignment
Quality Assessment Plan for Teachers
The ultimate aim of this training is to facilitate subsequent employment of the students. As teachers coming on to this program are skilled in information technology, at least to the level required to teach this course, but may not have had extensive experience in teaching and teaching techniques, this plan will help to assess the teachers in their teaching effectiveness....
16 pages (4016 words) Coursework
Learning Plan
On the other hand, many patients presenting in to the emergency department may not have that serious a clinical situation. However, an emergency nurse should be equipped with knowledge, expertise, learning, and clinical skills to handle these alone at her level....
6 pages (1506 words) Essay
Learning Plan Outcome Report
Patient assessment skills in the area of emergency nursing are important for several reasons (Sbaih, 2001). The most important of them is gradually increasing patient loads and increased waiting time. Nurses may segregate patients needing immediate attendance by being able to identify the patients with serious problems. This also fulfils two graduate qualities of the nurses, which are ability to apply knowledge in real situations and ability to identify the methodological and substantive limitations of the field and to apply a disciplined mode of enquiry in practice. To be able to apply...
8 pages (2008 words) Essay
learning needs assessment
Coney Island Hospital is under the New York City Health and Hospital Corporation (HHC) which happens to be the county's the largest health care system in the region serving more than 1.3 million people in New York. The hospital system is comprised of eleven acute hospital care centers, four nursing facilities that are skilled, six diagnostic centre that also carries out treatment and at least eighty clinic that are set up in the community. Home based health care services are also offered to the residents by HHC health care system. 1...
6 pages (1506 words) Essay
Independent learning plan 2
ful in solving the children’s learning problems, and making the information (confidentially) available to the people that are directly connected with the children’s learning processes (Snow & Hemel, 2008)....
5 pages (1255 words) Essay
Assessment 3
Both sets of findings were evaluated using perceptual maps. High taste will reflect the high quality and high entertainment is intended to serve as an excitement factor besides communicability to help maintain high customer satisfaction. Initially, the likely early adopters will be targeted specifically to ensure a successful start. Their traits are also identified in the report, and the brand name is justified. Recommendations are then given to address a number of possible issues that may arise and in anticipation of opportunities for learning....
8 pages (2008 words) Essay
Got a tricky question? Receive an answer from students like you! Try us!