MGCR-331-F22-S11-Excel3-Fin-Charts-PRACTICE-ANSW

Click into it and you will be able to see it clearly, please help

Help with the last question: your income will be $_____ per year

do assignments using excel and manually if possibly A student plans to open a business with the courage to borrow $1740,11 and will return the same amount every year for 5 years. If the loan interest from (Small Business Credit) is 6%/year. How much is the student's installment/year?

Click and you will see it clearly, please help

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Can you fill in the tables and answer the questions? I would appreciate it If you could also explain how to plug this into a financial calculator. Here's a link to a financial calculator: http://www.fncalculator.com/financialcalculator?type=tvmCalculator

You Can Do It! PRACTICE EXERCISE 3: EVALUATION: Use a separate paper to create a projected balance sheet worksheet with the following information: 1. You have P1250 in your checking account. 2. You have P1750 in your revolving savings account. 3. You purchased a computer last summer and it is valued at P500. 4. You received a graduation gift of a watch and it is valued at P300. 5. You purchased new furniture for your apartment at P1,000, but you still owe P400. 6. Your car is valued at P5,000, but you still owe P1,500. 7. You owe P300 on a credit card. 8. You have put P1,000 into a retirement plan, Prudential life. 9. You participate in your employer's 401k program. You have saved P5,000. 10. You need a root canal procedure at your dentist office. You owe P400. 11. You just cashed your income tax refund of P1,000 12. You purchased a flat-screen TV that is valued at P500. 13. You haveP75 in cash. 14. You have a student loan balance of P20,000. 15. You purchase a condo for $60,000 and…

help  please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

Use the present value and future value tables to answer the following questions. Time Value of Money - Principles of Accounting, Volume 2: Managerial Accounting | OpenStax A. If you would like to accumulate $2,400 over the next 5 years when the interest rate is 15%, how much do you need to deposit in the account? $_____ B. If you place $6,200 in a savings account, how much will you have at the end of 6 years with a 12% interest rate? $_____ C. You invest $7,000 per year for 11 years at 12% interest, how much will you have at the end of 11 years? $_____ D. You win the lottery and can either receive $760,000 as a lump sum or $60,000 per year for 19 years. Assuming you can earn 8% interest, which do you recommend and why? _____

A borrower has two alternatives for a loan: (1) issue a $630,000, 75-day, 6% note or (2) issue a $630,000, 75-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Compute the amount of the interest expense for each option. Round your answer to the nearest dollar. for each alternative. b. Determine the proceeds received by the borrower in each situation. Round your answers to the nearest dollar. < (1) $630,000, 75-day, 6% interest-bearing note: $ (2) $630,000, 75-day note discounted at 6%: $ c. Alternative is more favorable to the borrower because the borrower

Can you fill in the tables and answer the questions? I would appreciate it If you could also explain how to plug this into a financial calculator. Here's a link to a financial calculator: http://www.fncalculator.com/financialcalculator?type=tvmCalculator

Show all the steps and the math as well. Show all formula and answers in excel do questions from 1-5 that’s important

Please help me answer parts D and F ONLY. Thank you!

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

do the task with excel and manually if possible.thx A fishing pond entrepreneur has a plan to build and needs money through a loan with a bank interest of 10%/year. Borrowed money now $1740, year 2 $ 1392 and in the fourth year $1950. A.)How much money must be paid if the payment is made in the 6th year. B.) How much money must be paid annually, if payments are made annually for 10 years

Goal To use recursive sequence to determine the amount money owed on a loan after months Role You are a loan officer at a mortgage company. Audience Jim and Joan Miller are customers applying for a mortgage. Situation Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly payment is determined to be $758.48. Performance Task You need to present Jim and Joan with a report detailing the following: • Arecursive formula for their balance after each monthly payment has been made. • To do this, use the formula: a, = an-1 (1+r) – 758.48 A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment! • Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment. • Determine when the balance will be below $75,000. • Determine when the balance will be paid off. • Determine the interest expense when the loan is…

Abm (business math questions) can you help me?

Please indicate what you entered into your calculator to solve these problems. 1. You graduated with $28,000 in school loans. You will make annual payments of $4,000 at the beginning of each year for the next 10 years. What annual rate of interest are you being charged on your school loans? 2. You bought equipment for $23,000 and agreed to make monthly payments at the end of each quarter for 5 years. Assuming you are being charged 9% interest compounded QUARTERLY, how much will your QUARTERLY payments be? 3. You currently have $750,000 in your building fund. If you start depositing an additional $20,000 per year into this account at the beginning of each year, how much will be in the account after 6 years assuming 5.5% interest compounded annually? 4. You want to start saving for a new car and have decided to put S$90 per month at the beginning of each month into an account which earns 6% compounded monthly. You would like to be able to buy a car for $25,000. (a) How many deposits will…

Can you fill in the tables and answer the questions? I would appreciate it If you could also explain how to plug this into a financial calculator. Here's a link to a financial calculator: http://www.fncalculator.com/financialcalculator?type=tvmCalculator

Solve the problem and what is asked. Write your answer on clean paper clearly and readable. Don't forget to show your answer then box the final answer.

Exploring Annuities with Microsoft Excel I. Objectives: To organize data and perform calculations using Microsoft Excel To find future values for an annuity To determine payment amounts for an annuity given a set goal To analyze the effect of time To research reasonable annuity rates and investment amounts for use in the above calculations II. Procedure: Sheet 1 - Future Value 1. Open a new Microsoft Excel (or Google Sheets) blank spreadsheet. 2. At the bottom of the page, it will show "Sheet 1". You can rename it "Future Value". a. Right click the "Sheet 1" tab and you will see an option to rename it. 3. Type "Payment Amount (P)" in cell A1. 4. Type "Rate (i)" in cell B1. 5. Type "Number of Payments per year (n)" in cell C1. 6. Type "Years (t)" in cell D1. Now the research.. You need to investigate reasonable annuity rates for our current market. You can choose a rate of your own using the information you find. Also, I want you to find out what investors suggest your payment amount…

please help me and show casflow diagram if needed. and also  please,show complete solution please