本次online quiz代考主要为excel金融相关的problems

问题
#13
你决定贷款。贷款金额为 60,000 美元。你知道你将不得不支付1000
美元在每个月的月初,超过 7 年。名义利率会是多少?
#14
还是这个例子,如果我们修改一些参数会发生什么?让我们说
付款小 10 倍,即每月 100 美元。我们能看到什么?或者让我们决定在那里
应该只有2次付款。你如何解释结果?甚至更好 – 只需支付 1 次
全部的。它有多大意义?
最后,单次付款应该多高才能将费率精确设置为 0?
#15
假设您有 1,000,000 美元,但不知道如何处理。因此,有人拥有你
提供两种 20 年投资选择,每年资本化。
 第一次报价:以非常温和的利率 1% 开始,但每次增加 2 个百分点
投资年份。
 第二个报价:利率在整个投资期间保持不变:20%。
您应该选择哪个优惠?
#16
面值 100,000 美元且期限为 9 个月的票据必须替换为等值的
11 个月到期的票据。名义贴现率为 16%。面值是多少
替代品

Problems
#13
You decided to take a loan. The loan amount is 60,000 USD. You know that you will have to pay 1000
USD in the beginning of each month, over 7 years. What will be the nominal interest rate?
#14
Staying with the same example, what happens if we modify some parameters? Let’s say the
payment is 10 times smaller, i.e. 100 USD monthly. What can we see? Or let’s decide that there
should be only 2 payments. How can you interpret the result? Or even better – only 1 payment in
total. Does it make much sense?
Finally, how high should be a single payment to set the rate exactly to 0?
#15
Suppose that you’ve got 1,000,000 USD and no idea what to do with it. Thus, someone has you
offered two options of 20-year investment, with annual capitalisation.
 First offer: it starts with a very modest interest rate 1%, but rises by 2 percentage points each
year of investment.
 Second offer: the interest rate is constant throughout whole the period of investment: 20%.
Which offer should you choose?
#16
A bill with face value 100,000 USD and maturity of 9 months has to be replaced with an equivalent
bill with maturity of 11 months. The nominal discount rate is 16%. What will be the face value of the
replacement?