Practica Exam #1

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

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…

Each Section should be completed in a separate spreadsheet tab and all calculations should be performed using Excel formulas:   You graduated from college and landed a new job that will start in a couple of weeks. You need to purchase a car to commute to and from your new place of employment. You have decided to buy a car that costs $40,000, and will make a $5,000 down payment, resulting in the need to take out a $35,000 loan with a 5% annual interest rate that you will pay off in equal monthly installments over the next 5 years (60 months). Calculate and provide the following information:   a) Calculate the monthly payment on the car loan.   b) Prepare an amortization table for the car loan that provides separate columns for the following for each month of the car loan: Beginning loan balance; total payment amount, amount of monthly payment allocated to interest; amount of monthly payment allocated to the principal balance; and ending loan balance. (Your amortization table is likely…

Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.

1 Start with a Blank Excel Workbook           2 Your data will consist of the information provided below         3 Determine the Monthly Payment using the "PMT" formula       4 Create a detailed amortization schedule for the number of months below     5 Amortization schedule must include Interest calculation and a running balance     6 Create a Payment Dates Balance Lookup that uses the VLOOKUP formula to return the Balance for a given date 7 Extra credit (Use a Drop-Down list to select the Look up Date using "Payment Date" from your amortization scheduled 8 Format your document to only print the summary information without the amortization schedule (print on 1 page)                   Purchase Amount:    $  29,000.00             Down Payment Amount    $    1,000.00             YourName Loan Amount    $  28,000.00     (Summary Information)     Term (months):   36             Interest Rate (APR):   3.50%             Starting Date   12/7/2021…

Download the attached Excel file (First Q Profits Report W Goal Seek_Ver2.xlsx). Instructions: . There are 3 Worksheet Tabs in this Excel file; First Q, First Q Goal Seek, and Minivan Loan. • The First Q (First Quarter) tab shows the first quarter revenue and expenses of the Downtown Internet Cafe. For this tab, • Complete the Proportion column, cells G7 through G11 Each proportion value shows the % of the quarterly sale of that item over the entire sale. Calculate the Net Income row, cells B24 through F24. o Compute the Profit Margin row, Cells B25 through E25. o Add Net Income Sparkline for January through March in Cell H24. in For this tab

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

General Instruction: Use Yellow paper for your computation and answer. Task 1. Compute the interest of the following: 1. P25,000 at 6% simple interest for 1 year. 2. P30,000 at 9.5% simple interest for 90 days. 3. P60,000 at 12.5% simple interest for 2 years and 6 months.

File Tools View UTS MK I GSL 20-21 (19.10.20 -13.30) - Word (Product Activation Failed) W UTS MK I GSL 20-21 (19.10.20 -13.30) * x Document2 Problem 1 Balance Shet Income Statement PT. MaTaHtari PT. MATAH+ari For the year Ended December 31 For the year Ended December 31 2019 2018 ASSET Sales Revenue 10.000.000.000 Cash 550.000.000 700.000.000 Cost of Good Sold 6.400.000.000 Marketable Securities 500.000.000 300.000.000 Gross Profit Account Receivable 700.000.000 550.000.000 Inventory 750.000.000 650.000.00D 3.600000.000 Total Currevt Assit 2.500.000.000 2.200.000.000 Operating Expenses Selling Expenses 200.000.000 Gross Fixed Asset 3.000.000.000 General & Administrative Expenses 150.000.000 4.000.000.000 Less : Accumulated Depreciation Depreciation Expenses 250.000.000 500.000.000 200.000.000 Nett Fred Assit Total Operating Expenses 3.500.000.000 2.800.000.000 600.000.000 Operating Profit TOTAL ASSET 6.000.000.000 5.000.000.000 3.000.000.000 Interest Expenses JABILITIBS E STOCKHOLDER'S…

You are considering the following two projects and can take only one. Your cost of capital is 10.7%. The cash flows for the two projects are as follows ($ million): a. What is the IRR of each project? b. What is the NPV of each project at your cost of capital? c. At what cost of capital are you indifferent between the two projects? d. What should you do? a. What is the IRR of each project? The IRR for project A is%. (Round to one decimal place.)

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!!!!!!!

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…

Use cells A6 to B12 from the given information to complete this question. You must use the built-in Excel function to answer this question. Leave the "Basis" input blank in the function.

DO IT IN EXCEL AND SHOW FORMULAS DO IT IN EXCEL AND SHOW FORMULAS Jorge Del Llano, a start-up merchant, needs $360,000.00 liquid to invest in inventory and pay certain start-up expenses for his business. The Bank has investigated him and considers him eligible for credit. The Bank authorizes an unsecured credit facility, subject to the provision of a line of credit appropriate to your needs, charging 18% interest for a term of 60 days. The origination fee is 1.25%. For what amount was the loan signed for Del Llano to receive the $360,000 free of charge?

Can I know how to solve this?

1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…

Assignment - 11. Quiz: Savings Accounts SECTION ASSIGNMENTS COURSES Attempt 1 of 1 1 2 3 4 Which functions denotes the value of a car loan that accrues 18% annual simple interest for t years? Of (t) = 10000 + 120t Og(x) = 10000 + 12t Oh(x) = 12000t Ok (x) = 10000 1.12t NEXT QUESTION O ASK FOR HELP S Type here to search

Please see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.

Learning Activity No. 2 – Abstraction (Critical Thinking) Instructions: Fill in the blanks and calculate the monthly payments for a car loan having the details as provided below. Item Computation Sticker price of a car Excise tax Licensing Fee Down Payment Annual interest rate "r" Number of payments a year Number of years Periodic rate of interest i Php 1,700,000.00 20% Php 20,000.00 35% 6.0% 12 3 Answer: Loan PV Answer: PMT Answer: