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 ...Show more

Summary

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
Learning Plan 3 Assessment essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Learning Plan 3 Assessment"
with a personal 20% discount.
Grab the best paper

Related Essays

Planning, Assessment and Evaluation of Learning
The role of the teacher is not confined to the provision of knowledge to the child with special needs but also to stimulate, direct and promote the child to seek knowledge by himself (Rosy 2009). The paper focuses on the development of a medium term unit of work of about four to six weeks for a group of pupils with SEN in Key Stage 3.
6 pages (1500 words) Essay
Assessment for Learning
This educational approach of students has several propositions for the design of the course content, interactivity of courses, curriculum, assessment and evaluation process. MCAST is the leading post-secondary vocational education and training institute of Malta.
8 pages (2000 words) Essay
Learning and Teaching Assessment
According to the paper the responsibility of the mentor is to teach, assess and guide the student. As such, he or she should act as a role model for the student. It is by reviewing of the assessment documentation that the mentor is able to confirm the learning outcomes that the student is expected to achieve. It is always advised that the mentor and student be on the same shift for effective guide and support.
8 pages (2000 words) Essay
Learning Plan
It is true that many a cases presenting in to the emergency department may be beyond the skill realm of an emergency nurse, and these cases would eventually need intervention of a trained emergency physician, but nurses in these scenarios may at least draw the attention of the doctors the earliest.
6 pages (1500 words) Essay
Learning Plan Outcome Report
Based on my learning, I am required to develop a fact sheet for undergraduate nursing for undergraduate nursing students. Before going ahead to develop the product in this assignment, a brief overview of my learning in my previous assignment may be pertinent for reference.
8 pages (2000 words) Essay
Learning needs assessment
Today, the hospital has increased in size and has been in a position of catering to all the community's illnesses. The hospital has been well recognized for being able to treat thyroid cancers of high incidence of the survivors in Ukraine and Russia that was caused by an accident that was caused by Chernobyl nuclear reactor.
6 pages (1500 words) Essay
Independent learning plan 2
Hence, the following four reasons are presented as to why it is important to conduct the Assessment, what should be included in it and how it should be implemented. (c ) Assessment offers useful information that would be
5 pages (1250 words) Essay
Assessment 3
w/high entertainment product, and a second survey helped to identify the target market, which will be for a biscuit with a high degree of taste and highly associated with entertainment. The positioning therefore are the twin qualities of high taste and high entertainment, which
8 pages (2000 words) Essay
Learning and teaching assessment
My practice setting involves only five students in a clinical setting with mannequins. The procedure is the Lumbar Puncture and involves a lot of practice before it can done on real human. The students
8 pages (2000 words) Essay
Personal learning plan
Similarly, the sharing of the learning plans among the groups of students enhances the group process by instilling values that center on self-directing and identification of the collective learning
6 pages (1500 words) Essay
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT