Question: 1) Write a VBA subroutine to calculate PMT. Your programme should have Input Boxes for users to provide Loan amount, Rate of returns (r) and

1) Write a VBA subroutine to calculate PMT. Your programme should have Input Boxes for users to provide Loan amount, Rate of returns (r) and the number of period (n). It should display the results in a message box.

2) Write a present value calculator subroutine. Your subroutine should ask the user for the cashflow value, the interest rate, and the number of periods. It should then display the result in a message box. Sensible default values should be supplied for all arguments. Do not use the Excel function PV ; write your own present value function and use it.

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!

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

Develop a Java application that computes monthly payment for a car loan based on the credit score, loan amount, and loan term in months. The interest rates are loaded from the file that corresponds...

Assignment RapidBus is a commuter bus company.On regional route A, RapidBus currently charges $10 per passenger (fare).Monthly revenue for this route is $108,000.Currently variable cost is $5 per...

RapidBus is a commuter bus company.On regional route A, RapidBus currently charges $10 per passenger (fare).Monthly revenue for this route is $108,000.Currently variable cost is $5 per passenger and...

Assignment RapidBus is a commuter bus company.On regional route A, RapidBus currently charges $10 per passenger (fare).Monthly revenue for this route is $108,000.Currently variable cost is $5 per...

Cat & Joe's Pig Rig: Should We Stay or Should We Go? Tony Bell Thompson Rivers University Andrew Fergus Thompson Rivers University INTRODUCTION When the invitation arrived. Joe Thompson and Cathy...

Need help with the following problems. Instructions are the following (please note that is all the info I have): PROJECT STEPS Liam Richardson is the business manager for the Smith & Lyngate...

The SAMPLE database from your DB2 installation contains many tables. By using the STAFF table (35 rows) & ORG table (8 rows), answer each of the following questions using a single SQL statement....

LEssence is a small cosmetics company located in the perfume center of Grasse in southern France. The company plans to introduce a new body oil, called Energique, for which it needs to develop a...

Assignatent for Homework Homerork C Sign up I Chege / IntegratedAssignmentOverview , aspi 7 homeworkld = 6 9 8 4 6 8 2 0 1 ment for Section 1 3 . 5 Question Part 1 of 4 Consileted: 1 of 1 0 My scorr:...

Q11 The velocity distribution in the flow of a thin film of oil down an inclined channel is given by (d v) sin | 2 = velocity where d = depth of flow, a = angle of inclination of the channel to...

A single value for the resistance suffices to describe the behavior of the device over the range. Transformer acitor Transistor Ohmic resistor The total resistance of a two similar wire conductors...

Find the equivalent resistance in the figure. Also find the current at 5 ohm-resistor if 35 V is applied. * 12.0 N 4.00 2 5.00 2 6.00 8.00 2 O 14.6 ohms and 1 A 12.93 ohms and 2 A 11.7 ohms and 3 A...

Characteristics of a device or machine that tends to create electron flow. * EMF IMF ESF EF If you need a 1.25 kQ resistance and you only have resistors of 5 kQ, how many of these available resistors...

A single path for electric current through all of its components. * series-parallel series network O parallel For a non uniform current, the transferred charge will vary with the current changes...

SCENARIO Sarah is a postgraduate student researching the impact of artificial intelligence ( Al ) on higher education. During her initial literature search, she comes across a variety of sources: A...

Calculate the amount of the child and dependent care credit allowed for 2012 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...

Rebecca and Walter Bunge have been married for 5 years. They live at 883 Scrub Brush Street, Apt. 52B, Las Vegas, NV 89125. Rebecca is a homemaker and Walt is a high school teacher. Rebecca's Social...

Fisafolia Corporation has gross income from operations of $220,000 and operating expenses of $160,000 for 2012. The corporation also has $20,000 in dividends from publicly traded domestic...

Outline a programme of marketing communication activities that would not be intended to persuade customers to purchase.

Consider the notion of a marketing communication life cycle in which activities change to meet the communication needs of customers. Map an outline to illustrate this.

Try to explain human cognition processes using Vickers idea of an appreciative system. In what ways does this help in understanding the product brand from the cognitive and communication perspectives?