Assignment #2 SPREADSHEET
xlsx
School
Michigan State University *
*We aren’t endorsed by this school
Course
311
Subject
Finance
Date
Feb 20, 2024
Type
xlsx
Pages
5
Uploaded by KidFogOyster36
FI 311 - Spring 2023 - ASSIGNMENT #2
Rules:
*
You must calculate your answers in this spreadsheet. Then you must do the following:
Submit your spreadsheet to the Assignments dropbox in D2L. SPREADSHEETS SUBMITTED TO CONNECT OR EMAILED TO ME WILL NOT BE GRADED.
*You must show your work to get credit for a correct answer. Answers entered without any work shown will receive a grade of 0.
*Each question is worth 5 points; incorrect answers will be awarded 2.5 points. Questions not answered will receive 0 points.
*The Assignment is due on Tuesday, Feb. 21 at 10pm.
*Late assignments will be assessed a 7.5 point penalty, increasing by 7.5 points every 12 additional hours completed after the due time.
*No late assignments will be accepted after 10pm on Thursday, Feb. 23.
Problem 1
120
monthly rate: 0.0056666666667
FV: 4925.2512590704
Problem 2
The down payment:
230000
how much loaned:
2070000
51.7255607511306
40018.8991667915
Problem 3
41,400
3%: 0.03
FV:
48956.144157689
($10,112.79)
Upon graduation you receive $2500 in gifts, which you decide to invest for 10 years. If you earn 6.8% annually on your investment, compounded monthly, how much will you have in the account at the end of the 10th year? So we will have 4,925.25 dollars in the account at the end of the 10th year
You want to buy an Audi Q3 on your 26th birthday. You have priced these cars and found that they currently sell for $41,400. You believe that the price of this model will increase by 3% per year until you are ready to buy. You can presently invest to earn 6.5% annually. If you have just turned 20 years old, how much must you invest per year to be able to purchase the car in cash in 6 years?
Per year you invest 10,112.79 to purchase the car in 6 years The CEO of your company wants to buy another Bugatti Veyron, but he will need to get a loan to buy it. The bank is willing to give him a 5-year loan at 6% interest, but they are requiring him to make a 10% down payment. The car costs $2,300,000. How much will the monthly payments be?
The monthly payments on the car will be 40,018.90 dollars.
Problem 4
1.072
PV:
13992.537313433
You would want 13,992.54 dollars Problem 5
mon payment
1562.5
-3456334.9752
Rate:
Monthly interest rate = 0.01
NPER=
360
FV = $179,950.76 PV = $182,644.96 Problem 6
1.1334615816707
13.34615
13.34% Annual Return on Investment
Problem 7
You have won a game show prize of a trip to Tahiti in one year valued at $15,000. If instead, you are able to take the present value of the trip in cash, how much cash would you want if the rate you can earn is 7.2% annually, compounded annually?
You would want 13,992.54 dollars You have just graduated from MSU, and have landed a job with a starting salary of $75,000 per year. You have decided to buy a house, and you have $10,000 saved up from your part-time job at Qdoba. The Eighth National Bank of DeWitt is offering to give you a 30-year mortgage at 9.7% annual interest with monthly payments, but they will not give you a loan that will involve monthly payments of more than 25% of your income. Assuming you will borrow as much as you can from this bank, and assuming closing costs of 4% of the amount borrowed, what is the highest price you will be able to pay for the house?
The highest price you will be able to pay for the house would be 182,644.96 dollars A company invests $1 million to clear land and plant pine trees. The trees will mature in 10 years and the company expects to sell them for $3.5 million. What will be its annual rate of return on this investment? c
You want to buy a parcel of land in an area of town in the direction of future development. The lot costs $55,000. The monthly payments on a loan to buy the lot would be $805.76. If the bank is charging you 9% interest per year, how years will it be before you own the land, free and clear?
9669.12
5.68821154355308
Using PVAF table finding 9% and 5.68 We would get 9 years before you own the land Problem 8
10643.7840258714
Each month you must invest 10,643 dollars
Problem 9
PV:
182365.344221536
The most you should invest is 182,365.34 dollars Problem 10
PV = 205009.87179738
PV after 5 years = 287013.82051633
492023.69231371
Problem 11
1% 0.1100034850902
You have become bored with your job, you decide to start your own business. A new business takes money, so you start a 5-year plan. At an interest rate of 6 percent per year, how much must you invest each month to have $60,000 in your new business fund in 5 years? The engineering staff at the Sun Shipping Company has informed decision-makers that substantial money can be saved on the fleet's fuel bills if the ships' engines are adapted. Based on the cost of fuel, the engineers estimate that the firm will save $50,000 each year for the first 5 years and save $70,000 per year for the following five years. If these estimates are accurate, what would the company be willing to pay to adapt the engines? The company can earn 7% annually on its investments.
The company would pay up to 492,023.69 dollars to adapt the engines
An industrial bank will loan you $7,500 for two years to buy miscellaneous equipment for your firm. The loan must be repaid in equal monthly payments. The amount of the monthly payments will be $349.56. What annual rate of interest is the bank charging you? The bank is charging us 11% annual interest rate. You friend has developed a new design of mouse trap that he said works better than any other mouse trap available. He needs money for production, so he has asked you to invest in the new venture. He is offering you a percentage of the profits for the next seven years, and has estimated your share of the cash flows in Year 3 to be $55,000, increasing by $20,000 per year through Year 7 (there will be no cash flows in Years 1 or 2). You have decided this is a pretty risky proposition, so you are requiring a return of 18% annually. What is the most you should be willing to invest in this project?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Problem 12
Monthly interest rate = 0.0091666666667 2.7392698
NPER= 32.871237771455
Problem 13
2
25
Problem 14
FV= $326,661.53 Rate= 0.01
NPER=
60
PMT=
3999.79
PV=
$179,810.71 Problem 15
You have just withdrawn $143,806.59 from your investment account. You started with $50,000, made monthly payments into the account in the amount of $2,000, and received an annual interest rate of 11%. How many years was this investment in place?
2.7 years was how long the investments were in place
What is the value of a perpetuity that pays a quarterly dividend of $0.50 and has a required rate of return of 8%?
The Value of perpetuity is 25
You plan to buy a new BMW i8 5 years from now. You expect the price of this model of car to increase by 5% per year over the next 5 years. You have calculated that, when you buy the car 5 years from now, your monthly payment will be $3999.79, based on a 5 year loan at 12% annual interest. What is the current price of the car?
The current price of the car is 179,810.71 dollars Ingham Airlines has leased out a jet under a 12-year arrangement. The lease requires the lessee to pay Ingham Airlines annual payments of $600,000 beginning next year. If Air Atlantic can invest at 6 percent annually, what is the lease arrangement worth to it? the lease agreement is worth 5,030,306.36 million dollars after 12 years.
$5,030,306.36 BONUS PROBLEM
100000=640.38(1.03)^n
(used natural log to solve) ln(156.15)/ln(1.03) = 170.87 months 170.87/12 = 14
You want to start saving for your daughter's college education now. She will enter university at age 18, and you have decided to put $100,000 into an account to fund her education when she turns 18. If monthly deposits of $640.38 will allow you to reach your goal, how old is your daughter now? Assume you can earn 3% annual interest on your savings, compounded monthly.
It will take 14 years for her to reach her goal so if her daughter is 1 years old when she started she would be 15 by the time she can save that much money.
Related Documents
Related Questions
Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?
arrow_forward
Please avoid solution image based thnx
arrow_forward
Since i have posted a question with multiple sub-parts, you will solve the first three sub-parts for me. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.” In the first part and I do not have the step 3 ,I have only the steps 2 and steps 4. The second picture I will send you is the sub-parts and the # you need to resolved is the #4 and #5. Thank you! I'm looking forward to wait for the rest of my homework. Have a nice day!
arrow_forward
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
arrow_forward
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
arrow_forward
Details on pics. #4, #5, #6, #12 thank you .
arrow_forward
Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing
arrow_forward
Hi, I answered part A and my answer was 2.60%. Is that correct? Also, I need help with answering question 15
arrow_forward
experience during your exam
m. You will be given an additional ten minute submission window to allow you submit your exam to mitigate for any tecce 5sues you m
Click Save and Submit once you have completed the exam.
Itiple
empts
Not allowed. This Test can only be taken once.
rce
mpletion
This Test can be saved and resumed later.
Your answers are saved automatically.
Question Completion Status:
Close Window
A Moving to another question will save this response.
Question 2
«Question 2 of 10
Goremann Corp (GC) has a total market value of $524 million. The market value of equity is $300 million and the company carries debt valued at $224 million. The before-tax cost of debt is 9
percent and the cost of equity is estimated at 14 percent. The statutory company tax rate is 35 percent. What is the weighted-average cost of capital for the company closest to?
O A. 9.34%.
O B. 10.52%.
3 points
Save Answer
O C. 11.63%.
O D. 12.05%.
A Moving to another question will save this response.
Question 2 of…
arrow_forward
The first part of the assignment is to open Excel and in column A starting in row 1 and down to row 40 generate random values using the RAND() function. Copy and special paste those values onto sheet2. You will turn in the Excel file, but you will use the information below when directed.
Say an individual is faced with the decision of whether to buy auto insurance or not (like before laws in many states changed). The states of nature are that no accident occurs (with probability .992) or an accident occurs (with probability .008).
Here is the payoff table for the decision maker (where -500 is read minus 500, for example)
State of Nature
Decision No Accident Accident
Purchase insurance -500 -500
Do not purchase Ins. 0 -10000
1. Say the individual is a RISK LOVER. Create a table with plausible values of utility for the risk lover where you pick as the indifference probability for the value -500 the first value that is appropriate from your simulation in Excel (starting in cell A1 on…
arrow_forward
#18 and #19. Details on pics
arrow_forward
Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2)
Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed,
compound. 4) In the "ANSWER" cell show us your TVM calculation.
Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an
LG2-Q8 emergency fund within one year (no additional payments).
What would the quarterly interest rate be needed to reach this goal?
Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card
LG2-Q9 by the end of the year. (future is a $0 balance)
What would be the monthly payment to reach this goal?
Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future
LG2-Q10 is a $0 balance)
How many months will it take to complete this goal?
in fuo (no
Compounding Number
(select from dropdown)
4
Compounding Number
(select from dropdown)
12
Compounding Number
(select from…
arrow_forward
How would I calculate this problem? I just guessed on which answer made sense to me. Please help. thank you in advance.
arrow_forward
The following are selected accounts and balances for Mergaronite Company and Hill,
Inc., as of December 31, 2021. Several of Mergaronite's accounts have been omitted.
Credit balances are indicated by parentheses. Dividends were declared and paid in
the same period.
Revenues
Cost of goods sold
Depreciation expense
Investment income
Retained earnings, 1/1/21
Dividends declared
Current assets
Land
Buildings (net)
Equipment (net)
es
Liabilities
Common stock
Additional paid-in capital
Mergaronite
Hill
$ (594,000) $ (246,000)
266,000
104,000
NA
106,000
44,000
NA
(888,000)
(598,000)
140,000
36,000
210,000
696,000
316,000
94,000
510,000
142,000
212,000
240,000
(396,000)
(310,000)
(292,000)
(38,000)
(46,000)
(922,000)
Assume that Mergaronite acquired Hill on January 1, 2017, by issuing 6,600 shares of
common stock having a par value of $10 per share but a fair value of $100 each. On
January 1, 2017, Hill's land was undervalued by $20,000, its buildings were
overvalued by $31,000, and equipment…
arrow_forward
Can I get help plz and can you email me I have 2 more questions if possible gutierrezfj48@yahoo.com
arrow_forward
BOR
Tutor - Solution Page 1 of 1 | Ha X
A learn.hawkeslearning.com/Portal/Lesson/lesson_certify#!
MSC SSO Login
To Do Assignments.
E Reading list
E Apps
BSA Violation Civil... Search FAQS for Indian Trib...
CPAJ The Past, Present, a...
CPAJ Fraud in a World of...
You were asked to answer the following question:
Consider a small photography studio with 8 workers and 5 printers. The total cost of labor and capital is $3,300. In order to reduce total operating costs, the
owner leases 5 additional printers and fires 5 workers. After these changes, the salary of each worker increases by $30, the cost of using each of the printers (both
new and old) remains constant, and the total cost of labor and capital decreases to $2,950. What is the cost of using one printer?
The following answer is correct:
First, calculate the new total quantities of workers and printers after the changes were made.
New quantity of workers= 8-5= 3 workers
New quantity of printers = 5 + 5 = 10 printers
Assume that C,…
arrow_forward
Accounting practice problem (first three sub parts have been answered , just need remaining sub parts answered)- I attached a picture of the instructions and I attached a picture of the excel spreadsheet. Anywhere it says "formula" on the excel spreadsheet, needs the formulas (answers).
arrow_forward
My question is How do I find the formula for Cell A11 and where do I need to calculate those so that I can work on that easily before putting in Excel?
arrow_forward
All details are on pics. I need answer for #2
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
Directions
1
Given
cose =
2, and is in Quadrant 1, what is tane?
You must show all of your work to receive credit for this problem.
Please choose one option to complete this activity.
Sketchpad
FILE UPLOAD i
Question 7
OR
1
File Upload
Upload your work. Show all steps to receive credit for this problem.
arrow_forward
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Do not provide Excel Screet shot rather use tool table
Answer completely.
arrow_forward
Further info is in the attached images
For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B34 enter the formula "= B9".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50.
Thank you!
arrow_forward
Please correct answer and step by step solution
arrow_forward
The following  transactions occurred for Lawrence engineering
Post the transactions to the T-accounts
arrow_forward
How do I complete the journal entries for the attached problem? Specifically OCI?
arrow_forward
can someone give me a decription and or analysis of the following:(SEE PICTURE ATTACHED) THANK YOU! MERRY CHRISTMAS.
Not graded.
arrow_forward
I need help with 4 "Required" below in the second picture, creating journal entries, creating T-accounts, preparing an unadjusted trial balance, and preparing an unadjusted income statement, statement of SE, and classified balance sheet from the trial balance in (3). I need help badly!
arrow_forward
My first question is...are my general journal entries correct? Second question is...What number would be the warrant revenue for year 1?
Please see attachments,
Thank you!
arrow_forward
I have attached photos of the question. I need help with question 4. Question 4 asks us to find the break even number (units) of cases per month.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- Hi there! I've been stuck on these two problems for > two hours now and I'm not at all sure what to do. Is there any way someone can help me?arrow_forwardPlease avoid solution image based thnxarrow_forwardSince i have posted a question with multiple sub-parts, you will solve the first three sub-parts for me. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.” In the first part and I do not have the step 3 ,I have only the steps 2 and steps 4. The second picture I will send you is the sub-parts and the # you need to resolved is the #4 and #5. Thank you! I'm looking forward to wait for the rest of my homework. Have a nice day!arrow_forward
- 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 workingarrow_forwardhelp 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 workingarrow_forwardDetails on pics. #4, #5, #6, #12 thank you .arrow_forward
- Alert for not submit AI generated answer. I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writingarrow_forwardHi, I answered part A and my answer was 2.60%. Is that correct? Also, I need help with answering question 15arrow_forwardexperience during your exam m. You will be given an additional ten minute submission window to allow you submit your exam to mitigate for any tecce 5sues you m Click Save and Submit once you have completed the exam. Itiple empts Not allowed. This Test can only be taken once. rce mpletion This Test can be saved and resumed later. Your answers are saved automatically. Question Completion Status: Close Window A Moving to another question will save this response. Question 2 «Question 2 of 10 Goremann Corp (GC) has a total market value of $524 million. The market value of equity is $300 million and the company carries debt valued at $224 million. The before-tax cost of debt is 9 percent and the cost of equity is estimated at 14 percent. The statutory company tax rate is 35 percent. What is the weighted-average cost of capital for the company closest to? O A. 9.34%. O B. 10.52%. 3 points Save Answer O C. 11.63%. O D. 12.05%. A Moving to another question will save this response. Question 2 of…arrow_forward
- The first part of the assignment is to open Excel and in column A starting in row 1 and down to row 40 generate random values using the RAND() function. Copy and special paste those values onto sheet2. You will turn in the Excel file, but you will use the information below when directed. Say an individual is faced with the decision of whether to buy auto insurance or not (like before laws in many states changed). The states of nature are that no accident occurs (with probability .992) or an accident occurs (with probability .008). Here is the payoff table for the decision maker (where -500 is read minus 500, for example) State of Nature Decision No Accident Accident Purchase insurance -500 -500 Do not purchase Ins. 0 -10000 1. Say the individual is a RISK LOVER. Create a table with plausible values of utility for the risk lover where you pick as the indifference probability for the value -500 the first value that is appropriate from your simulation in Excel (starting in cell A1 on…arrow_forward#18 and #19. Details on picsarrow_forwardApplication Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound. 4) In the "ANSWER" cell show us your TVM calculation. Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an LG2-Q8 emergency fund within one year (no additional payments). What would the quarterly interest rate be needed to reach this goal? Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card LG2-Q9 by the end of the year. (future is a $0 balance) What would be the monthly payment to reach this goal? Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future LG2-Q10 is a $0 balance) How many months will it take to complete this goal? in fuo (no Compounding Number (select from dropdown) 4 Compounding Number (select from dropdown) 12 Compounding Number (select from…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education