FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please explain this in excel with formulas 1) 1 You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest

please explain this in excel with formulas
image text in transcribed
1) 1 You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The frequency of your periodic equal payments to be made in a year is 2. What will be the approximate modified duration of this fixed payment loan? Group of answer choices 1.238 2.000 1.192 1.215

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Tech In Finance

Big Tech In Finance

Authors: Igor Pejic

1st Edition

139860898X, 978-1398608986

More Books

Students also viewed these Finance questions

Question

★★★★★
An automatic valve consists of a 225 Ã 225-mm square plate that is pivoted about a horizontal axis through A located at a distance h = 90 mm above the lower edge. Determine the depth of water...

Answered: 1 week ago

Question

★★★★★
14. The Retro Appliance Company forecasts demand for its blenders during 12 months as the following: The current production work force level for the company is 35 employees, and each employee can...

Answered: 1 week ago

Question

★★★★★
Water is added to pure sulfuric acid in a well-insulated flask initially at 25C and 1 atm to produce a 4.00-molar sulfuric acid solution (SG = 1.23 1). The final temperature of the product solution...

Answered: 1 week ago

Question

★★★★★
Knight Inventory Systems, Inc., has announced a rights offer. The company has announced that it will take five rights to buy a new share in the offering at a subscription price of $33. At the close...

Answered: 1 week ago

Question

★★★★★
A company is analyzing a proposed project. The company expects to sell 4,750 units, plus or minus 6 percent. The expected variable cost per unit is $360 and the expected fixed costs are $610,000....

Answered: 1 week ago

Question

★★★★★
A retrospective associational study examined the medical utilization of homeless veterans receiving treatment in a Veterans Affairs health care system (LePage, Bradshaw, Cipher, & Hooshyar, 2014). A...

Answered: 1 week ago

Question

★★★★★
Which one of the following technologies is not directly related to Big Data? Group of answer choices Spark Hadoop MapReduce OLAP

Answered: 1 week ago

Question

★★★★★
Mr. Brown just won the lottery. The lottery will pay Mr. Brown 6 annual payments, with the first payment occurring today (Year 0) and the last payment occurring 5 years from today (Year 5). Todays...

Answered: 1 week ago

Question

★★★★★
A golf ball is struck across a flat fairway at an angle of 60 with an initial speed of 135ft/s. a.). Write a set of parametric equations for the motion of the golf ball. b.). Determine how long the...

Answered: 1 week ago

Question

★★★★★
At December 31, 2023, Halifax Servicing's balance sheet showed capital asset information as detailed in the schedule below. Halifax calculates depreciation to the nearest whole month. 1 There have...

Answered: 1 week ago

Question

★★★★★
2. Describe the uses of the job description and person specification/competency profile in the recruitment process.

Answered: 1 week ago

Question

★★★★★
plan and conduct an interview and assess the candidate, recording and justifying your decisions and provide feedback to candidates

Answered: 1 week ago

Question

★★★★★
3. What approaches to recruitment can an employer adopt in order to create and project a positive public image?

Answered: 1 week ago

Previous Question Next Question