04 Mar You are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field. In the atta
you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field.
In the attachment you have
– the "Download Instructions" file and
-the "additional resources" files inside the zip files.
-the pdf is the general project instruction with the grading criteria.
- similar work done by another student in excel file
this project is due by Sunday march 5, by 11:59 eastern time. but I prefer it to be done before 4 pm.
Project 2: Financial Project
Due Sunday by 11:59pm Points 100 Submitting a file upload
Financial Project Possible Rubric
Start Assignment
As an Ivy Tech student, you are making an investment in your education. This project will look at how
that investment will pay off if you graduate and get a job in your desired field.
Download instructions: financial_project_Summer_22.docx
(https://ivylearn.ivytech.edu/courses/1184729/files/107282151?wrap=1)
(https://ivylearn.ivytech.edu/courses/1184729/files/107282151/download?download_frd=1)
Project should be your original work. This project is to be completed by individual students.
Copying someone else’s work is cheating. Sharing your work with someone else is cheating.
Tips: Start early. Ask instructor or tutors for help. Refer to course materials (book, videos).
Complete as much as you can, a partial submission is better than no submission. Writing
tutors are also available for assistance.
Some additional resources: Mathematical Organization for Projects.docx
(https://ivylearn.ivytech.edu/courses/1184729/files/107282152?wrap=1) (https://ivylearn.ivytech.edu
/courses/1184729/files/107282152/download?download_frd=1) Citation examples – websites.docx
(https://ivylearn.ivytech.edu/courses/1184729/files/107282150?wrap=1) (https://ivylearn.ivytech.edu
/courses/1184729/files/107282150/download?download_frd=1)
Submit both an Excel and Word file following your instructor’s directions for submission.
Project 2: Financial Project https://ivylearn.ivytech.edu/courses/1184729/assignments/17830541?re…
1 of 3 3/3/2023, 4:09 PM
Criteria Ratings Pts
5 pts
5 pts
5 pts
5 pts
5 pts
5 pts
5 pts
5 pts
20 pts
10 pts
5 pts
Explain Career 5 pts
Full Marks
0 pts
No Marks
Compare Salaries 5 pts
Full Marks
0 pts
No Marks
Loan Value 5 pts
Full Marks
0 pts
No Marks
Loan Interest 5 pts
Full Marks
0 pts
No Marks
401k Value 5 pts
Full Marks
0 pts
No Marks
401k Interest 5 pts
Full Marks
0 pts
No Marks
Compare Loan and 401k 5 pts
Full Marks
0 pts
No Marks
Raise value and explanation of how you calculated it 5 pts
Full Marks
0 pts
No Marks
Excel and Math Explanation 20 pts
Full Marks
0 pts
No Marks
Paper contains at least 2 correct Rel Ch Statements 10 pts
Full Marks
0 pts
No Marks
Answered all questions in description 5 pts
Full Marks
0 pts
No Marks
Project 2: Financial Project https://ivylearn.ivytech.edu/courses/1184729/assignments/17830541?re…
2 of 3 3/3/2023, 4:09 PM
Total Points: 100
Criteria Ratings Pts
5 pts
5 pts
10 pts
5 pts
Conclusion – what have you learned? 5 pts
Full Marks
0 pts
No Marks
Excel organized 5 pts
Full Marks
0 pts
No Marks
Presentation, Org, Coherence, Grammar, Style 10 pts
Full Marks
0 pts
No Marks
citation of sources/reference page in proper format 5 pts
Full Marks
0 pts
No Marks
Project 2: Financial Project https://ivylearn.ivytech.edu/courses/1184729/assignments/17830541?re…
3 of 3 3/3/2023, 4:09 PM
,
Math 123 Quantitative Reasoning Project Summer 2022
Financial Project
As an Ivy Tech student, you are making an investment in your education. This project will look at how that investment will pay off if you graduate and get a job in your desired field.
1) Income Comparison: Research your expected income after you graduate. Assume you obtain whatever level of education needed to enter your desired area of employment. We recommend using the annual Median salary found at: http://www.bls.gov/oes/current/oes_in.htm#27-0000 *You will need to click on your desired career in order to see the Annual Median wage. If using a different source, you must cite it.
· Your reflection paper should explain what your desired area of employment is and what the median annual salary for that position is. Explain why you chose this field and what education is required.
· Suppose the annual income for an unskilled worker is $24,000. Compare your expected salary with that of the unskilled worker. Remember that absolute and relative change statements are an excellent way to compare values.
2) Spending vs. Saving: With your post-graduation income, you have disposable income to spend or invest as you like. Explore what would happen if you spent 1/10th of your monthly income on a loan payment versus investing 1/10th of your monthly income into a retirement account?
· Research and choose a current fixed rate APR for a loan for a length of your choice then use Excel to determine how large of a loan you would receive using 1/10th of your monthly income as a loan payment.
· How much interest would you pay on this loan total?
· If you were able to invest 1/10th of your monthly income into a retirement account with the same rate APR and length of time as you would have for the loan above, what would the balance on the account be at the end?
· How much interest would you earn on this investment total?
· Compare the outcomes for the loan value and the retirement value. Remember that absolute and relative change statements are an excellent way to compare values.
· Explain how you calculated the values used in this section including any Excel functions. Remember to cite what source you used to find loan rates.
3) Raises: Suppose your field will guarantee you a 3% raise on your annual salary each year for the next four years.
· Explain how you would determine what your new annual salary will be given these four years of raises.
· Your reflection paper should contain at least one statement comparing your initial salary with the salary after 4 years of raises.
· Paper must contain at least two meaningful relative change statements.
· Explanation of career choice and the salary for this career.
· Comparison of your expected salary vs. unskilled worker.
· Research and citation for a loan APR.
· Determination of loan value.
· Determination of interest paid on the loan.
· Explanation of how loan value and interest values were determined.
· Determination of retirement value.
· Determination of interest earned on the retirement account.
· Explanation of how retirement value and interest values were determined.
· Comparison of the loan amount and retirement amount.
· Determination of new salary after raises.
· Explanation of how you determined the new salary.
· Comparison of new salary with initial salary.
· Include in paper citations for any websites or other resources used.
· Paper should be elegant and coherent with a logical organization.
· Paper should be free of grammatical and mechanical errors.
· An organized spreadsheet with clearly labeled values.
· Completed project should be submitted via Ivy Learn on time in a readable format file.
In addition to addressing the statements above, your project should:
· Contain your name, course name and project name.
· Be well organized and easy to follow.
· The paper should be in paragraph form (not just bulleted answers!).
· Be clear to by someone who is not familiar with the project.
· Provide support for your statements e.g. explain how values were found.
· Give specific values (i. e. quantify statements).
· Use appropriate representations (tables, color, formatting) that helps the reader understand the project.
· Contain a variety of comparison statements, including the use of relative change sentences.
· Project should be your original individual work. Copying someone else’s work is cheating. Sharing your work with someone else is cheating.
· Tips: Start early. Ask instructor or tutors for help. Refer to course materials (book, videos). Complete as much as you can, a partial submission is better than no submission. Writing tutors are also available for assistance.
· Submit both an Excel and Word file following your instructor’s directions for submission.
image1.jpg
image2.gif
,
additional resources/Citation examples – websites.docx
Website Citation Examples – APA Format
A website with no identifiable author
When the content on a website has no identifiable author, use the name for the organization, corporation, or government agency as the group author and begin the entry with the group author. Place the title of the web page in italics. Include the URL address. URLs are generally black in a reference, but it’s not wrong if they are blue. If the website has no identifiable author, including no identifiable group author, you should use caution in selecting the source as it may not be a reliable reference.
In-Text Citation examples:
Sample 1
The website for the National Osteoporosis Foundation (2008) has many interesting facts about this debilitating disease.
Sample 2
Osteoporosis is a highly preventable disease (National Osteoporosis Foundation, 2008).
Sample 3
The National Osteoporosis Foundation (2008) stated, “Eighty percent of those affected by osteoporosis are women” (Osteoporosis Prevalence: Gender, para. 2).
Reference Citation:
National Osteoporosis Foundation. (2008). Fast facts. Retrieved from http://www.nof.org.
In-Text Citation:
Sample 4
Subaru of America (2004) makes it easy to compare its Outback with similar cars.
Sample 5
Subaru currently has five models in its lineup (Subaru of America, 2004).
Sample 6
According to Subaru of America (2004), “All Subaru Outback models blend the rugged versatility of an SUV with the driving performance and comfort of a passenger car” (para. 1).
Reference Citation:
Subaru of America, Inc. (2004). Subaru previews all-new. Retrieved from http://www.subaru.com.
A website with an author
In-Text Citation:
Sample 1
According to Copeland (2003), the adaptation required when minorities enter the workplace is a two-way street.
Sample 2
Diversity is a positive thing in the workforce (Copeland, 2003).
Sample 3
Copeland (2003) stated, “Diversity is emerging as one of the most serious issues in the workplace today, yet most employers are not prepared to deal with it” (Managing a Multicultural Workforce, para. 1).
Reference Citation:
Copeland, L. (2003). Managing a multicultural workforce. California Job Journal. Retrieved from http://www.jobjournal.com.
In-Text Citation:
Sample 4
According to Nix (2004), no definitive national Christmas tree exists.
Sample 5
Apparently, four trees could be the national Christmas tree in the United States (Nix, 2004).
Sample 6
Nix (2004) mentioned that “four trees touted to be the nation’s Christmas tree” (para. 1).
Reference Citaton:
Nix, S. (2004). The Amazon and neotropical rainforest. Retrieved from http://forestry.about.com.
additional resources/Mathematical Organization for Projects.docx
Mathematical Writing
Organizational Keys
When you write anything in college, it is vital that whatever you write is clear, organized, and fulfilling its intended purpose. When working on mathematics projects that involve essay writing, in particular, be sure that you not only have a firm understanding of the purpose of your assignment but that you choose the best form of organization to get your message across.
To begin, make sure that you provide some type of introductory paragraph that sets the stage and introduces what you are about to do; be sure to make it interesting and attention-getting! Namely, make sure that you answer the question(s) asked, and be sure to apply clear and concise language, necessary explanations, and any background information that will help you reach your intended goal with excellence!
Consider the following writing keys:
#1 Remember “KIS”; keep it simple:
Make sure that your answer clearly addresses the question asked.
#2 Use major details and minor details to organize what you write:
Be intentional and very deliberate in your planning and prewriting so that you group your ideas well into a logical order of understanding.
#3 Use paragraphs to help you separate your ideas:
When you change from one subject and/or concept to another, begin a new paragraph. Proper paragraphing has e-v-e-r-y-thing to do with the clarity of your writing and ultimately, the success of your paper!
#4 Be specific and quantify:
Avoid general comparisons like ‘a lot’, ‘some’, ‘a little’. This is a math class, so give specific quantities when describing or comparing values.
#4 Check for proper grammar and punctuation:
Make sure that you write complete sentences, avoid run-on sentences, and check for proper grammar (particularly subject-verb agreement), and capitalize and punctuate sentences appropriately. Microsoft Word automatically checks for some grammar and spelling issues but Excel does not! To spell check in Excel, go to the Review Tab. Start early so you can have a tutor proofread with you.
Tips for Visual Communication
When using Excel, be effective by being sensitive to do the following:
· Similar calculations should be grouped together
· Calculations should be shown in order of use; think in sequences
· Graphs should be clear and concise
· They should be easily seen, using a proper font size
· Use Proper Labeling of problems/graphics
· Calculations should use appropriate Excel functions
· All formulas can be viewed by pressing- Control~
· All Excel functions that are necessary to complete the project are in the Course Packet.
If you do your Math well, and you write well,
they’ll call you a GENIUS!
image1.png
image2.jpeg
image3.gif
,
Sheet1
| NAME: | xxxxxxxxxxxxxx | Desired Career: | Registered Nurse | Date: | April 14th, 2020 | |||
| FINANCIAL PROJECT | ||||||||
| Each green cell needs data (a value, a name, a date, or some words) | ||||||||
| Each yellow cell needs a formula (an Excel function like PMT, PV, FV or just addition, subtraction, multiplication, etc.) | ||||||||
| Format cells appropriately: – if the cell contains a monetary amount, make sure that you change its label/format to "Currency" or "Accounting". – if the cell contains a percentage, make sure that you change its label/format to "Percentage", etc. | ||||||||
| Part # | College Graduate with Desired Career | High School Graduate | Absolute Difference | Relative Difference | ||||
| 1 | Income Comparison | |||||||
| Annual Salary | $62,450 | $22,250 | $40,200 | 180.67% | ||||
| Monthly Salary | $5,204.17 | $1,854.17 | $3,350 | 180.67% | ||||
| 2A | Housing Comparison | |||||||
| Short Term Mortgage | ||||||||
| APR | 3.70% | 3.70% | ||||||
| Mortgage Term (Number of Years) | 15 | 15 | ||||||
| % of Monthly Income going to Mortage Payments | 25% | 25% | ||||||
| Monthly Mortgage Payments (Amount) | $1,301.04 | $463.54 | ||||||
| Mortgage Amount (Amount that can be borrowed) | $179,505.05 | $63,959.33 | $115,545.72 | $63,958.33 | ||||
| Long Term Mortgage | ||||||||
| APR | 4.24% | 4.24% | ||||||
| Mortgage Term (Number of Years) | 30 | 30 | ||||||
| % of Monthly Income going to Mortage Payments | 25% | 25% | ||||||
| Monthly Mortgage Payments (Amount) | $1,301.04 | $463.54 | ||||||
| Mortgage Amount (Amount that can be borrowed) | $264,755 | $94,340 | $170,416 | $94,339 | ||||
| 2B | Housing Comparison | |||||||
| Short Term Mortgage | ||||||||
| APR | 3.70% | 3.70% | ||||||
| Mortgage Term (Number of Years) | 15 | 15 | ||||||
| Dream House Value | $170,000.00 | $170,000.00 | ||||||
| Monthly Payments needed to finance dream house | $1,232.07 | $1,232.07 | ||||||
| Percentage of Monthly Income | 23.67% | 66.45% | -42.77% | -100.00% | ||||
| Long Term Mortgage | ||||||||
| APR | 4.24% | 4.24% | ||||||
| Mortgage Term (Number of Years) | 30 | 30 | ||||||
| Dream House Value | $170,000 | $170,000.00 | ||||||
| Monthly Payments needed to finance dream house | $835.30 | $835.30 | ||||||
| Percentage of Monthly Income | 16.05% | 45.05% | -29.00% | -54.95% | ||||
| 3 | Retirement Comparison | |||||||
|
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. 
About WridemyWe 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 WorksTo 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. Hire a tutor today CLICK HERE to make your first orderRelated TagsAcademic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA |