Question: Using Excel Calculation question 4. (6) Assume you can save $400.00 per month ( 10% of your new $40,000.00 Salary) after you graduate and you

Using Excel

Calculation question 4. (6) Assume you can save $400.00 per month ( 10% of your new $40,000.00 Salary) after you graduate and you think you can earn 8% annual returns on your investment, and you want to accumulate $2,000,000.00 before you retire. How long (months then convert to years) will it take to reach your goal? Calculation question 5. (6) Assume you just purchased a new tractor from John Deere and you financed $205,000.00 through their financing branch (John Deere Financial). You will make 5 annual payments at the end of each of the next 5 years of $48,247.00. What annual interest rate are they charging you? (don't forget to stretch your spreadsheet answer out to more places past the decimal than the Excel default)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

all i need is "required 1" & "required 6" On November 1 of Year 5, you were hired as the treasurer for Rayburn Processing. Part of your job duties include maintaining accurate records of the...

For the second part of the Exam, develop an Excel spreadsheet with clearly marked sections to answer each of the following questions using the appropriate formula's, and submit your spreadsheet...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Question 1 (show all workings) This question relates to material covered in the Topics 1 to 3. This question addresses the 5th and 6th subject learning outcomes. A thorough understanding of financial...

plz answer correctly Personal Budget Assignment Businesses use budgets to plan for the future. That's what you will be doing for this assignment. Rather than budgeting for your current financial...

Businesses use budgets to plan for the future. Thats what you will be doing for this assignment. Rather than budgeting for your current financial situation, I want you to put together a budget for...

Please answer me page 51 to page 56 on the attachment. is a multiple choice questions. Thank you FAC1502/101/3/2016 Tutorial letter 101/3/2016 Financial accounting concepts, principles and procedures...

UPIN18 2020 In order to receive credit for your answers, use Excel Financial Functions or Algebraic Time Value of Money Equations to answer these questions in your spreadsheet. See General Guide-...

Businesses use budgets to plan for the future. Thats what you will be doing for this assignment. Rather than budgeting for your current financial situation, I want you to put together a budget for...

This project is a comprehensive practice case. It is designed to help you apply knowledge and skills you have learned from BUS 370 to real world situation. In one or two years, you will graduate from...

Vhembe Engineering Ltd is a company based at Thohoyandou. It tenders for various size contracts in most parts of South Africa. It has recently successfully tendered for a Local Authority contract in...

Find the mean of the random variable whose moment- generating function is Mtu) = (1-11 )2(2-u)(3-1)

Laboratory 2 14 8. Describe the anatomical relationship between the liver and gallbladder. 9. Under what structure is the first incision made in order to open the abdominal cavity of the fetal pig?...

The following statement permits assembly if arg 1 is exactly the same as arg 2 ? ( case - sensitive comparison ) : IFIDN , Question 1 2 options: True False

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

4. Explain how understanding intercultural communication can facilitate resolution of intercultural conflict.

5. Explain how studying intercultural communication can lead to increased self-understanding.

5. Define and give an example of cross-cultural differences in facial expressions, proxemics, gestures, eye contact, paralanguage, chronemics, and silence.