x***w 发帖数: 11 | 1 一道Excel题,想了好长时间,找不出哪里做错了,题目是这样的
On Junuary 1, 2009. Bradley Recreational Products issued $100,000,9%, four-
year bonds Interest is paid semiannually on June 30 and December 31. The
bonds were issued at $96,768 to yield an annual return of 10%.
Required:
1, Prepare an amortization schedual that determines interest at the
effective interest rate.
2,Prepare an amortization schedule by the straight-line method.
3,Prepare the journal entries to record interest expense on June 30,2011,by
each od the t |
I*****e 发帖数: 319 | 2 Recorded 是你的的expense
Difference 是Armortized discount
第一栏是cash |
x***w 发帖数: 11 | 3 Ibelive, 非常感谢你的回答,
我的答案在下面,能帮我看看么?
Interest expense 4,911
Discount on bands payable 411
Cash 4,500
Interest expense 4904
Discont on bands payable 404
cash 4,500
check 出来说让我重试。。真是郁闷。。不知道哪里错了。。
【在 I*****e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : Recorded 是你的的expense : Difference 是Armortized discount : 第一栏是cash
|
x***w 发帖数: 11 | 4 May anyone give me any idea? |
B*********r 发帖数: 69 | 5 这么简单的题,还上网找人做作业。你应该回去好好看看书才对诶。 |
x***w 发帖数: 11 | 6 书是好好看了,觉得自己做的也对,可就是和答案不一样,几个同学也都是这个结果,
打算这样交上去了,想上来求证一下,知道这里的人牛的好多,看上一眼就知道结果了。
真是受打击。。
【在 B*********r 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 这么简单的题,还上网找人做作业。你应该回去好好看看书才对诶。
|
a*******e 发帖数: 97 | 7 My company laptop cannot open xlxs. Can you convert it back to the older
version of excel and re-post?
了。
【在 x***w 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 书是好好看了,觉得自己做的也对,可就是和答案不一样,几个同学也都是这个结果, : 打算这样交上去了,想上来求证一下,知道这里的人牛的好多,看上一眼就知道结果了。 : 真是受打击。。
|
x***w 发帖数: 11 | 8 Thank you so much. Attached is the original one.
【在 a*******e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : My company laptop cannot open xlxs. Can you convert it back to the older : version of excel and re-post? : : 了。
|
l*e 发帖数: 297 | 9 我的答案跟你的一样,不过我打不开你的文件.
知道正确答案了,贴上来吧,让俺也明白明白,嘿嘿.
four-
by
【在 x***w 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 一道Excel题,想了好长时间,找不出哪里做错了,题目是这样的 : On Junuary 1, 2009. Bradley Recreational Products issued $100,000,9%, four- : year bonds Interest is paid semiannually on June 30 and December 31. The : bonds were issued at $96,768 to yield an annual return of 10%. : Required: : 1, Prepare an amortization schedual that determines interest at the : effective interest rate. : 2,Prepare an amortization schedule by the straight-line method. : 3,Prepare the journal entries to record interest expense on June 30,2011,by : each od the t
|
x***w 发帖数: 11 | 10 好的,好的,很可能是答案有错,因为这次作业很重要,所以想弄清楚再交。谢谢。。
【在 l*e 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 我的答案跟你的一样,不过我打不开你的文件. : 知道正确答案了,贴上来吧,让俺也明白明白,嘿嘿. : : four- : by
|
a*******e 发帖数: 97 | 11 My answer happens to be the same as yours. See my spreadsheet in the
attachment.
Could the formulas in the spreadsheet be incorret? Sorry did not help much
【在 x***w 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 好的,好的,很可能是答案有错,因为这次作业很重要,所以想弄清楚再交。谢谢。。
|
x***w 发帖数: 11 | 12 Thanks, you already helped me. we will see the solution when the professor
give the homework back. |