Practica Exam #1

Please add the formulas too thank you

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…

Need help with this question solution general accounting

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

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

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…

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

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

Math Concepts 6. Exam 3 Name: Assume that the following loan was paid in full before its due date. Regular Monthly Payments $785 APR 6.5% Remaining Number of Scheduled Payments after Payoff 36 (i) Obtain the value of h. (ii) Find the amount of unearned interest by the actuarial method.