TheEllenBlog

Excel表格技巧:巧用RATE函数求利率

本教程适用版本:WPS 365 点击免费使用 当我们在财务计算的时候,常常会用到RATE函数,它可以帮助我们计算年金的各期利率。 以这个表格数据为例,我们已知贷款期限、每月支付额、贷款总额,现在要求贷款的月利率和年利率。 ■ 首先选中B5单元格,点击插入函数,找到RATE函数,点击确定。 》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘 ■ 此时弹出对话框,共六项参数。 支付总期数:总投资期或贷款期 定期支付额:各期应支出的金额 现值:需要付款的总金额 终值:付款后获得的余额,若忽略不填, 默认为0 是否初期支付:可填0或1。0是期末,1是期初,忽略不填默认为期末 预估值:给定利率的猜测值,忽略不填默认为0.1(10%) 我们在支付总期数填入B1,在定期支付额填入B2,在现值填入B3,点击确定,即可算出贷款的月利率了。 》免费升级到 WPS 企业版:多人协作在线文档,大容量企业云盘 ■ 要求年利率也很简单,就在月利率的计算公式后乘以12,点击确定,即可算出贷款的年利率。     Keyword: 手机号微信开通批量检测

Exclusive | Javier Pastore is PSG’s new number 10

Javier Pastore has been allocated the PSG number 10 shirt for the 2016/17 campaign, sources close to the player have told Get French Football News. Speculation emerged tonight during PSG’s friendly with Inter Milan after Pastore was seen with the #10 shirt. Many had been speculating that he was handed the shirt just in the event of Read more about Exclusive | Javier Pastore is PSG’s new number 10[…]

BASF to supply Neopentyl Glycol from Zhanjiang to Khua

BASF and Zhejiang Guanghua Technology Co.,Ltd. (Khua) have signed a Letter of Intent for the supply of Neopentyl Glycol (NPG) from BASF’s Zhanjiang Verbund site to Khua. Khua, a reputed manufacturer of saturated polyester resins for the powder coatings industry in China, is planning to build a 100 kilotons per annum (KT/a) production plant for Read more about BASF to supply Neopentyl Glycol from Zhanjiang to Khua[…]

BASF to divest Florida site to Clariant

BASF has reached an agreement to divest its manufacturing site in Quincy, Florida and the associated attapulgite business for a purchase price of USD 60 million (EUR 53 million) to Clariant. The Quincy mining facility employs around 75 employees and manufactures clay-based mineral products used in a variety of industrial applications. BASF’s attapulgite business generated Read more about BASF to divest Florida site to Clariant[…]

Winter Warm Extra Soft Heated Throw Electric Blanket for Winter

Basic Info. Model NO. customize Material Polyester Feature Waterproof, Electric Type Heated Blanket Knitting Method Machine Weaved Pattern Printing Pattern Usage Home, Travel, Hospital, Hotel Remark OEM, ODM, Customization Avaliable Sample Time 3 Days Delivery Time 30days After The Order Confirmed Logo Customize Voltage 24V Transport Package 1PC/Polybag,12PCS/CTN or as Customers′ Requirement Specification 1.5kg Trademark Read more about Winter Warm Extra Soft Heated Throw Electric Blanket for Winter[…]

Windproof Lightweight Portable Waterproof Polar Fleece 2 in 1 T

Overview Basic Info. Model NO. blanket Material Polar Fleece Fabric Age Group Adults, Children, Babies Feature Anti-Pilling, Portable, Waterproof, Windproof, Warm, Soft Type Raschel Blanket Knitting Method Warp Knitting Pattern Plain Color Usage Home, Hotel, Festival, Wedding Sample Time 3-5 Days Color Custom Colors Transport Package Custom Packaging Specification 100% Polyester Origin Changzhou Production Capacity Read more about Windproof Lightweight Portable Waterproof Polar Fleece 2 in 1 T[…]

Wholesalle Mimixiong Newborn Baby Knitted Security Throw Swaddl

Overview Basic Info. Model NO. 82W597 Material Cotton Age Group 0-2years Feature Anti-Pilling, Portable, Wearable, Disposable Type Knitted Blankets Knitting Method Warp Knitting Pattern Embroidered Usage Home, Travel, Airplane, Picnic, Hospital, Bath, Hotel MOQ 3PCS OEM/ODM Acceptable Delivery Time Inventory 3-5days Brand Mimixiong Colors Pink, Gray Sample Time 7 Days Support Transport Package Polybag and Read more about Wholesalle Mimixiong Newborn Baby Knitted Security Throw Swaddl[…]

Wholesales Different Color Office Warm Winter Gift Cute Fast El

Basic Info. Model NO. blanket Material Flannel Age Group All Group Feature Portable, Fireproof, Electric Type Blended Blanket Knitting Method Machine Weaved Pattern Plain Color Usage Home, Travel, Airplane, Hospital, Office Advantage Fast Heating Function Heating and Warm Keywords Heating Blanket for Office Ingredients Flannel Feeling Warm Transport Package Gift Specification 72*115 Trademark OEM Origin Read more about Wholesales Different Color Office Warm Winter Gift Cute Fast El[…]

Manchester United & Juventus to finalise Paul Pogba deal in the next 48 hours – Di Marzio

According to Sky Italia journalist Gianluca di Marzio, Manchester United and Juventus should close a deal for Paul Pogba in the next 48 hours. The Italian reporter claims that Juventus and Manchester United will agree a deal worth a little over €110m plus bonuses, with Manchester United to pay Mino Raiola’s agent fee, which is believed to be Read more about Manchester United & Juventus to finalise Paul Pogba deal in the next 48 hours – Di Marzio[…]

BASF gives final approval for the construction of the Zhanjiang Verbund site

BASF has given final approval for the construction of the planned Verbund site in Zhanjiang in the southern Chinese province of Guangdong. According to the company, the project is on schedule. As BASF has announced, the focus is now on building the core of the Verbund, which includes a steam cracker and several downstream plants Read more about BASF gives final approval for the construction of the Zhanjiang Verbund site[…]