show all excel formulas/ work answering the following: Computing EAR and APR 1 Suppose you can earn 1% per month on $1 invested today. What is the APR? How much are you effectively earning? Suppose if you put it in another account, you earn 3% per quarter. What is the APR? How much are you effectively earning? Future Values with Monthly Compounding Suppose you deposit $50 a month into an account that has an APR of 9%, based on monthly compounding. How much will you have in the account in 35 years? Present Value with Daily Compounding You need $15,000 in 3 years for a new car. If you can deposit money into an account that pays an APR of 5.5% based on daily compounding, how much would you need to deposit?

show all excel formulas/ work answering the following: Computing EAR and APR 1 Suppose you can earn 1% per month on $1 invested today. What is the APR? How much are you effectively earning? Suppose if you put it in another account, you earn 3% per quarter. What is the APR? How much are you effectively earning? Future Values with Monthly Compounding Suppose you deposit $50 a month into an account that has an APR of 9%, based on monthly compounding. How much will you have in the account in 35 years? Present Value with Daily Compounding You need $15,000 in 3 years for a new car. If you can deposit money into an account that pays an APR of 5.5% based on daily compounding, how much would you need to deposit?

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

I need the manual excel formula as well as the FV Excel Function. C. Suppose you save $2,800 a year for 43 years into an investment account that earn 8.5% return, how much will you have at the end of the periods? Formula $ ??? Excel Functon $1,066,616.08
Carla Vista Design has daily sales of $54,000. The financial management team has determined that a lockbox would reduce the collection time by 1.7 days. Assuming the company can earn 4.1 percent interest per year, what are the savings from the lockbox? (Round answer to 2 decimal places, e.g. 12.25.) what is the Savings from the lockbox per year?
Hello can you please walk me through how to do this the annual income is 113,300 It is wise to set aside 7.5% of gross monthly income for 401 k investment. Assume the investment earns a 5% annual return and use Excel to determine the balance after 40 years for the unskilled worker and for your expected income. Then use Excel to determine how many years it would take for the unskilled worker and for your expected investment to reach $500,000.
Please show in Excel Suppose that you deposit $200 at the end of each month into an account paying an expected annual rate of return of 3%, compounded monthly. How much money will you have in the account in 10 years? AnswerN I PV PMT FV
(USING EXCEL FUNCTION PLEASE) You wish to plan your Bahamas Islands vacation. You estimate that it will be two years from now, and that it will cost $15,000. The monthly payment you should save in order to finance your vacation is $637.66 assuming that you make 24 monthly payments, starting today and ending 23 months from now. what is the annual percentage rate?
A department store has it’s own credit card facilities, for which it charges interest at a rateof 4% each month. Calculate the annual percentage rate (APR). Explain why this is not thesame as charging an annual interest rate of 48% and what is APR.b) A proposed investment costs $1500 today. The expected revenue flow is $ 3000 at theend of year 1, and $10,000 at the end of year 2. Find the internal rate of return, correct totwo decimal places. The market interest rate is 15%. Would you recommend thisinvestment? Explain the reason for your recommendation.
Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no cost (i.e. you will pay your bills on a two month lag). Your monthly expenses for rent, wages, utilities, and so forth will be approximately $3,500 per month. You have deposited $15,000 in a checking account to begin your operations and would like to maintain a minimum balance of $5,000 in that account. 1. Explain the purpose of creating budgets and how your budget will help the business remain capitalized 2 . Will you need additional funds at some point? Justify your answer. 3. How would you raise capital in the future?
Compute the monthly payment on a car loan of $23,000 for 35 months, if the APR is 8.4%. Formula Excel Functon I need the formula as well as the excel function.
Pierre Martina is comparing the cost of credit to the cash price of an item. If Pierre makes a $150 down payment and pays $37 a month for 24 months, how much more will that amount be than the cash price of $752? (Input the amount as a positive value.)
Your best friend is saving $1,800.00 and will earn 0.17 percent per month. Determine the number of months until the account grows to $2,000.00.
Answer the questions below and show all working from a financial calculator. Do not use excel: 1. Investment promises to pay into an account that pays you 6 percent annually, $150 per month for the next twenty-two years. Suppose the first deposit into the account is made one month from today what is the value of the amount which will be in the account at the end ofthirty years? Rounded to 2 decimal places. 2. What will be the present value, if $5,400 is discounted back 4 years at an interest rate of 3% compounded semi-annually?
You have been investing $350 a month for the last 8 years. Today, your investment account is worth $43,262. What is annual rate of return? Group of answer choices 6.15% 7.87% 9.69% 7.15% 6.88%