EGH$4400 is deposited in a savings certificate at a bank at 3.5% interest.What is the effective interest rate if the money is compounded continuously?What is the effective interest rate if the money is compounded quarterly?Formatting Rules:■Create organized tables with proper column and0 row labeling1 Graphs should have proper labeling for both axis2 Formatting Rules:1314 Create organized tables with proper column and15 row labeling16 Graphs should have proper labeling for both axis17 Formatting Rules:1819 Create organized tables with proper column and20 row labeling21 Graphs should have proper labeling for both axis242522222L(Ctrl)

We'll find the effective interest rate for both continuous and quarterly compounding.Given:-…

Answered: E G H $4400 is deposited in a savings…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

Hi,how to use the excel function (IRR and Effect) to determine which money lender offers a better rate: 1. Ah Long Finance: Loan amount: $20,000; instalment $600 per month x 36 months 2. Sharky Finance: Loan amount: $30,000; instalment $555 per month x 60 months 3. Ah Beng Finance: Loan amount: 40,000; instalment $ 760 per month x 59 months 4. Barracuda Finance: Loan amount: $50,000; instalment $925 per month x 60 monthsThanks.
Direction: Solve what is being asked and show your complete and neat solution. (ROUND OF PV FACTORS TO 4 DECIMAL PLACES, ROUND OF FINAL ANSWER TO TWO DECIMAL PLACES. IN MCQs CHOOSE THE BEST ANSWER) C.) Which of the following bank accounts has the highest effective annual return? a. An account that pays 10 percent nominal interest with monthly compounding. b. An account that pays 10 percent nominal interest with daily compounding. c. An account that pays 10 percent nominal interest with annual compounding. d. An account that pays 9 percent nominal interest with daily compounding. e. All of the investments above have the same effective annual return.
Part 1. On the right are six diagrams representing six different present and future value concepts stated on the left. Identify the diagrams with the concepts by writing the identifying letter of the diagram on the blank line at the left. Assume n = 4 and i = 8%. Concept Diagram of Concept 1. Future value of 1. $1 + a. 2. Present value of 1. 3. Future value of an annuity $1 $1 $1 $1 b. |- - - H due of 1. + 4. Future value of an ordinary annuity of 1. ? $1 $1 $1 $1 5. Present value of an ordinary c. + ---I annuity of 1. 6. Present value of an annuity $1 $1 $1 $1 d. + due of 1. $1 e. F $1 $1 $1 $1 f. H + + Part 2. For each of the Concepts above provide an explanation of what it represents and include an example for each of a use in financial reporting.
Nelto deposits $2,500 in a bank account that pays 3% interest compounded quarterly. Two years later, how much do they have in their bank account? C 1 t=0 n Cash Flow Diagram ….....…... Time Value of Money (TVM) Framework PV PMT FV type How to compute using Excel? -function( rate, nper, pmt, [PV]. [type]) n CPT
Suppose that you borrow a loan of amount P from a bank at the end of month 3 and make the monthly deposits to the bank as in the cash flow diagram below. In the following cash flow diagram A7=A8=A9=1000, and starting with A10, deposits start decreasing in the amount of 40. However, due to a cash problem, you miss a payment at month 12 but continue with your original payment plan thereafter (that is, A10=960, A11=920, A12=0, A13=840 etc). With these payments, your dept to the bank will be 0 at the end of month 20. Assuming that the interest rate is 12% compounded monthly. 1-Find out the initial loan amount P. 2-Find the total interest paid to the bank
Choose the correct letter and provide solution A firm has total annual sales (all credit) of P100,000.00 and accounts receivable of P20,000.00. How rapidly (in how many days) must accounts receivable be collected if management wants to reduce the accounts receivable to P15,000.00? *a. 22.8 daysb. 34.8 daysc. 44.8 daysd. 52.8 dayse. 54.8 days
If your credit card balance is $650 and the interest rate is 12% APR, then the credit card interest charge is Group of answer choices A.$0.65 B.$65 C.$8.25 D.$6.50
Suppose a bank has the following Balance Sheet Assets Liabilities RSA = 120 RSL = 90 FRL = X FRA = 110 (Fixed rate liabilities can be found if needed by determining what number it must be to balance the balance sheet.) Suppose all the Assets and Liabilities were set last year when the interest rate was 10, if the interest rate has changed by 2% since that time what is the current cost from all of the bank's liabilities? Your Answer:
41. After conducting a rate-sensitive analysis, a bank finds itself with the following amounts of rate-sensitive assets and liabilities (RSAS and RSL) and fixed-rate assets and liabilities (FRAs and FRLs); the rate of return and cost rates on the accounts are also given: Assets RSAS @ 4.25% FRAS @ 5.15% NEA Total Amount (Million $) S 322 S 700 S 120 $1,142 Liabilities & Equity RSLS @ 3.11% FRLS @ 4.95% Equity Total If the bank wishes to set up a swap to totally hedge the interest rate risk, the bank should A. pay a variable rate of interest and receive a fixed rate of interest. B. pay a fixed rate of interest and receive a variable rate of interest. Amount (Million $) S 200 $ 800 S 142 $1,142 C. pay a variable rate of interest and receive a variable rate of interest. D. pay a fixed rate of interest and receive a fixed rate of interest.
A bank lends some money to a business. The business will pay the bank a single payment of $180,000 in ten years time. How much greater is the present value (PV) of this payment if the interest rate is 8% rather than 7%? A. $9,754 B. $6,502 C. $11,379 D. $8,128 Please use financial calculater variable entries.
1) Use the Loan worksheet to complete the loan amortization table.  In cell F2, insert the IPMT function to calculate the interest for the first payment. Copy the function to the range F3:F25. (The results will update after you complete the other functions and formulas.) 2) In cell G2, insert the PPMT function to calculate the principal paid for the first payment. Copy the function to the range G3:G25. 3) In cell H2, insert a formula to calculate the ending principal balance. Copy the formula to the range H3:H25. 4) Now you want to determine how much interest was paid during the first two years.  In cell B10, insert the CUMIPMT function to calculate the cumulative interest after the first two years. Make sure the result is positive. 5) In cell B11, insert the CUMPRINC function to calculate the cumulative principal paid at the end of the first two years. Make sure the result is positive. 6) You want to perform a what-if analysis to determine the rate if the monthly payment is…
Problem 1 Create a generic excel spreadsheet where the interest rate, i, can be changed at the top and all tabulated values in the rest of the sheet will change accordingly. DEF A Yr Interest= 2| n SINGLE PAYMENT UNIFORM SERIES 3 CAF (F/P) 4n(1+SCS)^A4 в G PWF SCA SFF SPW CRF (P/F) (F/A)(A/F)(P/A)(A/P) 58 Note: After creating this sheet, all problems can use the spreadsheet to create a table for any interest rate, i, or year, n, needed, instead of using the formulas. Use interest rate, i 10% and n = 8 years to calculate each factor in row 5.

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS