Write a payment schedule calculator subroutine. The subroutine is to ask the user for the sum of
Question:
Write a payment schedule calculator subroutine. The subroutine is to ask the user for the sum of the loan, the number of payments, and the interest rate. Assume payment at the end of the period. The output should look like the example below.
? You may want to use the worksheet function PMT.
? The following subroutine and its output might be of interest:
Here is an example of the requested subroutine in action:
Transcribed Image Text:
(General) StringConcat Sub stringConcat () Dim s As String $ = "Coll" & Chr(9) & "Col2" ' Chr (9) is the Tab $ = s & Chr (13) & "aaa" & Chr(9) & "bbb" MsgBox s End Sub Microsoft Excel x Col Col2 bbb aaa OK
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 90% (10 reviews)
The example subroutine provided is not directly related to calculating a payment schedule but I will help you create a subroutine for a payment schedu...View the full answer
Answered By
Ali Khawaja
my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Business questions
-
The question is to ask to compare the given option, For example, In A,D,E which is most reliable? In C,D,E which is most reliable ? In A,E,F which is most reliable? In B,D,F which is most reliable?...
-
3. A financial institution with total asset size of $2.6 million and asset dollar duration of $18.4 million has total liabilities of $1.6 million and dollar duration of $4.8 million. The duration of...
-
Here we look at some variations of Example 1.3.4. (a) In the warden's calculation of Example 1.3.4 it was assumed that if A were to be pardoned, then with equal probability the warden would tell A...
-
pick 1 1 point A small island nation has license plates that consist of 2 letters ( \( A-Z \) allowed) followed by 3 numbers (0 \( -9 \) allowed). How many plates are possible that do not repeat the...
-
Consider the correlations (in U.S. dollars) of worldwide bond markets presented in Exhibit 9.5. Explain the reasons for the correlations observed between the United States and other countries, and...
-
what are the types of non accounting and accounting assets used by IPH ltd(au) and McMillan Shakespeare Limited(au) in its operations for Integrated reporting? and how can they be compared between...
-
The Bonferroni-adjusted P-value is always greater than the uncorrected P-value. In Exercises 5 and 6, determine whether the statement is true or false. If the statement is false, rewrite it as a true...
-
The ownermanager of Good Guys Enterprises obtains utility from income (profit) and from having the firm behaves in a socially conscious manner, such as making charitable contributions or civic...
-
The return pattern on your favorite stock has been 5%, 8%, -12%, 15%, 21% over the last five years. What is your average return and total change in wealth per year over the period?
-
Ms. Tanja Umstead is 46 years old and lives in Richmond, British Columbia. She is in good health and works in the sales department of a large publicly traded company. Tanjas Personal Information: 1....
-
Rewrite the subroutine in the previous exercise so that the user interface is as demonstrated in the following screen shots. Some of the functions needed to write the subroutine were not covered in...
-
Rewrite the payment schedule calculator subroutine so it displays the payments broken down into interest and capital payments. The input boxes in the example were removed for compactness. Payment...
-
The stability criterion for the explicit method requires that the coefficient of the term of the one-dimensional, finite-difference equation be zero or positive. Consider the situation for which the...
-
hi can u paraphrase this and make it to 2600 words pls: not my work this is the essay I wrote these are the links I do need footnote as well. Journal articles: Ravnyshyn v Drys, [2005] BCJ No 831,...
-
Simplify the radical, then approximate it to two decimal places. 288
-
Analytically re-calculate the force R acting on point C. It will no longer be 687.5 N as previously found and listed in the slides 800 N 500 N A 55 40 40 D B 80 60 R C
-
complete the IRS tax return for tina's sole proprietorship business. complete form 1040 schedule c, and forms required by schedule c: forms 4562 (depreciation) and 8829 (home office) for tina's...
-
Why is inflation generally detrimental for bondholders or lenders?
-
Suppose that you must choose between two procedures for performing a hypothesis test-say, Procedure A and Procedure B. Further suppose that, for the same sample size and significance level, Procedure...
-
QUESTION 2 The CEO of Farisha Hijab Sdn Bhd insisted on further investigation to be carried out that he also required Mr Muaz to conduct the analysis of variance for the material and labour of the...
-
How did information technology affect decision making at Team USA and the Oakland Athletics? What kinds of decisions changed as the result of using computers?
-
How much was technology responsible for Team USAs Americas Cup victory?
-
How much does baseball rely on sabermetrics? Explain your answer.
-
The balance in the Raw Materials Inventory account at January 1 , 2 0 2 3 was $ 1 , 5 1 6 . During the year, the company purchased $ 4 6 1 , 4 8 9 of raw materials and paid raw materials invoices...
-
During the coming accounting year, Baker Manufacturing, Inc., anticipates the following costs, expenses, and operating data: Direct material (16,000 lb.) Direct labor (@ $10/hr.) Indirect material...
-
Three grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk oil is $1.50 per gram. Budgeted production...
Study smarter with the SolutionInn App