Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Maverick numbers are named after a famous student who studied Financial Modeling at the University of Texas at Arlington in the 21 century. Maverick numbers

image text in transcribed
image text in transcribed
image text in transcribed
Maverick numbers are named after a famous student who studied Financial Modeling at the University of Texas at Arlington in the 21 century. Maverick numbers are defined as follows. M(0 0 M(2)-2M(1) M(3) 3+M(2) M(n)-n+M(n-1) (a) Write a function that computes the Maverick number for a user-provided n. You must use recursion in this function. Name this function "Maverick" and use it to compute Maverick numbers for n- 1, 2, 3,4, 10, 75, and 100 (b) Now rewrite the function but you must use Do While in the function Name this function "Maverick2" and use it to compute Maverick numbers for n 1, 2, 3, 4, 10, 75, and 100 Write a macro that uses the Maverick function you have written in Problem I Name your macro as MaverickCalc This macro should ask the user to input the number n as follows Please input the number n The title of the box that asks for the above input should be: Input for Maverick Number Calculator No default input value should be provided for n The result should be displayed in a message box that states the following The Maverick number for n is: Note that the number n above should be displayed as the actual number provided by the user.) The title of the box that provides the above output should be Maverick number calculator The above output should be displayed in an information box (i.e., you need to use Vblnformation) Page I of 3 PROBLEM III Consider an annuity that pays a fixed amount of C every time period for n periods. If the discount rate is r, the PV of this annuity is: (a Write a function to compute the PV of an annuity. You must use recursion in this Name the function "AnnuityPV" and use it to compute the PV of an annuity that pays SI ,000 at the end of each year for the next 7 years. The discount rate is 8% per year (b) Now rewrite the function but you must use Do While in the function. Name this function "AnnuityPV2" and use it to compute the PV of an annuity that pays $1,000 at the end of cach year for the next 7 years. The discount rate is 8% per year Write a macro that uses the AnnuityPV function you have written in Problem III Name your macro as AnnuityPVCalc This macro should ask the user for the inputs: C, r, and n. These inputs should be asked for as follows: Please input the cash flow: Please input the interest rate: Please input the number of periods: The title of each of the box that asks for the above input should be: Input for Annuity PV Calculator For cach of the above, the following default values should be supplied. (User carn overwrite these default values to provide the new values) Cash flow of 1 ,000, interest rate of 5% or 0.05, and number of periods as 10. -The result should be displayed in a message box that states the following The present value of the annuity is: The title of the box that provides the above output should be: Annuity PV Calculator Output Page 2of 3 PROBLEM V Fibonacci numbers is a sequence of numbers named after Italian mathematician Leonardo Pisano, better known by his nickname of Fibonacci. In this sequence, every number after the first two is the sum of the two preceding ones. The Fibonacci sequence is defined as follows. F(0) 0 F13)=2)+F( 1 ) = 1+1-2 F4)-F3)+F2)-2+1-3 In general, Fin) Fin-1+Fn-2) Write the Fibonacci function described above. You must use Do While in this function, Use this function to compute the Fibonacci numbers for n = 1, 2, 4, 8, 12, 16, 20, and 24. Write a macro that uses the Fibonacci function you have written in Problem V Name your macro as FibonacciCalc. -This macro should ask the user to input the number n as follows Please input the number n: -The title of the box that asks for the above input should be: Input for Fibonacci Calculator -No default input value should be provided for n. -The result should be displayed in a message box that states the following. The Fibonacci number for n is: Note that the number n above should be displayed as the number provided by the user.) -The title of the box that provides the above output should be: Fibonacci number calculator The above output should be displayed in an information box (i.e., you need to use

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Start An Online Business In 7 Steps

Authors: Mr Tolga Cakir

1st Edition

0993303803, 978-0993303807

More Books

Students also viewed these Finance questions