The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

pleaaaaaaase help I will pay you 50\$

Question 1 [10 marks] Refer to Question 7 of the revision problems from week 04.

1. [2 marks] Use Goal seek to solve the question in a spreadsheet. Make sure you carefully document the steps you used in the spreadsheet.
2. [2 marks] Use Solver to solve the question in a spreadsheet. Make sure you carefully document the steps you used in the spreadsheet.

Next, develop an effective interest rate calculator.

c. [6 marks] The calculator you develop should satisfy the following spec- ifications.

• In the top cell the user enters the percentage nominal rate (like 7%).
• In the next cell the user enters the annual frequency of the nom- inal rate, i.e., the n from jn.
• In the next cell the spreadsheet calculates the effective daily rate of interest. (Assume 365 days in a year.)
• In the next cell the spreadsheet calculates the effective weekly rate of interest. (Assume 52 weeks in a year.)
• In the next cell the spreadsheet calculates the effective monthly rate of interest.
• In the next cell the spreadsheet calculates the effective quarterly rate of interest.
• In the next cell the spreadsheet calculates the effective half yearly rate of interest.
• In the next cell the spreadsheet calculates the effective annual rate of interest. Graph your results, displaying the log interest rate1 on the vertical axis and the nominal, then effective rates, on the horizontal axis (in the order given above). Present your answers to the above questions in a spreadsheet, giving each solution on a separate sheet (labelled ‘Part a’, ‘Part b’, and ‘Part c’). Your spreadsheet should be clearly labelled and easy to understand. Make sure you identify what the “inputs” and “outputs” are.

## GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.