急 1000币 求助 银行贷款问题

问题如下：

A bank lends money to its customers on mortgage repayable by equal fortnightly instal-
ments using a quoted interest rate of 5.5% per annum. The outstanding balance is initially
the amount of the loan and the balance is reduced by any instalments received.

At the end of each month simple interest is charged based on the average daily balance for
the month and the number of days in the month. The bank rounds all interest charges up
to the next fifty cents. For example if the balance at the beginning of March is $100,000
and an instalment of $1,200 is received on March 14th, then simple interest (assuming 365
days in a year) will be charged for 14 days on $100,000 and for 17 days on $(100,000 –
1,200) and then rounded to the next 50 cents.

Estimate the fortnightly repayment required to extinguish this loan out on the first
repayment date on or after 14 June 2027. This estimate will require adjustments to
allow for months of different length, the fifty cent interest rounding adjustment, and
leap years. Explain and justify the adjustments you make.



要求：
1、在一周内完成（在5月22号之前）
2、不能用excel 逐个数值尝试，需要下个一个可分析的公式（即能够用计算器可算得答案的公式）
3、如果在三天内完成再补偿1000币。

谢谢

帮楼主顶一个啊！

Jasonluo 发表于 2012-5-14 22:13
帮楼主顶一个啊！

谢谢仁兄～！想了很久都不知道怎么做的说。。

Jasonluo 发表于 2012-5-14 22:13
帮楼主顶一个啊！

谢谢仁兄～！想了很久都不知道怎么做的说。。

先看看哈

楼主好有币，可惜这题我不会，继续当穷人

可否翻译一下

=ROUNDUP(A1*2,0)/2
这个是关于rounded to the next 50 cents的公式，其他的很多公式我都忘了，悲剧。

分期付款，每两周结算一次余额，年利率5.5%，

楼主，你最后一段的第一句出现两个on的哪里是不是有啥问题，搞不懂你是啥意思，