Q1:- A contractor who has a construction mechanism that he presents to rent for his data as in the following table, answer the questions in the table if you know that the contractor wants profits equal to the interest rate and there is no tax and operating and maintenance costs on the tenant: Purchase price (millions of dinars) 109 useful life (year) 15 Interest rate 0 Book value (million dinars) at the end of year 8 using the cashback method Find the 69.936 rental price at the end of year 9 using the sum of years digit method?
Q: Firm X needs 1 computer. There are two options available: Firm X can buy 1 computer for 2,000; or…
A: Computation of cost of leasing:
Q: Q3:- An investor wants to establish a cement plant, so if the data for the plant is as below, and…
A: Investment = $309,000,000 Production cost = $27 Annual costs of depreciation = $7,725,000 Annual…
Q: Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It can obtain…
A: Calculation of Cost of Owning, Cost of Leasing and NAL of Lease: Excel Spreadsheet: Excel Workings:
Q: XYZ Builders need to acquire the use of a crane for construction business, and are…
A: Leasing an asset can be defined as taking an asset for a specified period of time by paying some…
Q: Show excel formula please. Reymundo purchases a property for $300,000. He gets a 2.00% 30 yr fixed…
A: The PMT function or concept can be used to determine the periodic payments required to accumulate a…
Q: Robin Williams has just purchased some equipment for his business. For this equipment he must pay…
A:
Q: b) Homeshare rents out various newly built properties to low-income families. It has recently rented…
A: Answer: (i): Calculation of the present value of rental income assuming it is expected to continue…
Q: process of utilizing excel to finance properties. Consider the following. A realator has a house on…
A: In this we have to calculate the present value FACTOR monthly payment using EXCEL functions.
Q: Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise…
A: Answer- (1) Rate is represents the interest rate for loan, nper is represents the no. of payment, PV…
Q: New Venture Corporation has taken out a $5 million, 30-year, 10% mortgage on its new manufacturing…
A: A written agreement through which a lender gets the right to take the property that is put as a…
Q: You have just purchased a new car! You made a down payment of $5,000 and financed the balance.…
A: Given:Down payment from today => $5,000Monthly payment => $600Term period => 48 months (4…
Q: Sharon Fox decided to buy a home in Marblehead, Massachusetts, for $265,000. Her bank requires a 25%…
A: a.
Q: Q. XYZ Builders need to acquire the use of a crane for construction business, and are considering…
A: Lease and buy decisions are a kind of capital budgeting decisions that an investor or a company…
Q: 1) USE THE AMORTIZATION TABLE TO ANSWER THIS QUESTION: Bob Jones bought a new log cabin for $…
A: Calculation of monthly payment amount From the amortization table, the monthly payment amount is $…
Q: Question 3 a) A man bought a car for 2.5m cedis in 2020. He paid 40% of the cost and paid the rest…
A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question…
Q: rt Neuner, an investor in real estate, bought an office condominium. The market value of the cc…
A: Gievn Data; Tax Rate: $32.50 per $1,000 Condominium Fees = $140 per month General repair, insurance…
Q: Reynolds Construction (RC) needs a piece of equipment that costs $200. RC can either lease the…
A: Hey, since there are multiple subpart questions posted, we will answer the first three subpart…
Q: 1. Lucy Heartfillia buy a television set from a merchant who offers P25,000 at the end of 60 days.…
A: Future Value: Using an expected rate of growth, future value (FV) is defined as the worth of a…
Q: Suppose that you borrowed $18,306 for 36 months to buy a car last year at 5.5% APR compounded…
A: given, p= $18306 n = 36 r= 5.5% m = 12 ( monthly compounding)
Q: An equipment distributor that sells construction equipment has a promo to attract customers. The…
A: A sell on loan is a facility provided to buyer to purchase the asset and make the payment over a…
Q: buying or renting equipment is shown as follows: Current assets Fixed assets Total assets $ 300 Debt…
A: Purchasing equipment is expensive, and it may be impossible for many small businesses to buy…
Q: questions. Q: A wel-informed, photographed, and a contractor who has contracts that include mound…
A:
Q: 1. A Contractor charges an Engineer Php. 2,750.00 on a loan of Php. 15,800.00 for 2 years and 3…
A: Simple interest is the interest calculated on principal amount.
Q: An asset costs $420,000 and will be depreciated in a straight-line manner over its 3-year life. It…
A: Hai there! Thank you for the question. Post has multiple questions. As per company guidelines expert…
Q: What is the PV of your windfall?
A: The today’s worth of dollar at a later date is the Present Value of the dollar. For example, the…
Q: Stuart Rentals can purchase a van that costs $105,000; it has an expected useful life of three years…
A: Payback Period: The payback period is the amount of time it will take for you to recoup the cost of…
Q: Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise…
A: Here, Selling price for the property = $410,000 Rate of interest = 11% Number of years = 20 years To…
Q: (Ignore income taxes in this problem.) Your Company’s cost of capital is 3%, It is contemplating the…
A: The net present value of purchasing the equipment will be the difference between the present value…
Q: A condominium unit can be bought at a down payment of P150,000and a monthly payment of P10,000 for…
A: Down payment (D) = P 150000 Monthly payment (M) = P 10000 n = 10 years = 120 payments r = 12% per…
Q: Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It can obtain…
A: Calculation of Cost of Owning, Cost of Leasing and NAL of Lease: Excel Spreadsheet: Excel Workings:
Q: A house and lot are to be purchased by paying P 15,500.00 monthly payable in 25 years. The first…
A: Present Value of annuity due formula will be used to calculate the value of house and lot as the…
Q: wo plans are available for a company to obtain automobiles for its salesmen. How pe driven each year…
A: In this both options are equal in term of cost and mileage.
Q: A manufacturing firm purchased a heavy duty drilling machine. They were given two payment options:…
A: Option 1: Immediate payment of $39000 needed. Option 2: Immediate payment of $23500 and remaining…
Q: What is the approximate IRR of an asset that (1) sells for $1,120, (2) exists for only 6 years and…
A: The internal rate of return method is an important capital budgeting method that takes into account…
Q: If money's worth is 7% today and you are looking for a property worth P1M. How much is the discount…
A: The time value of money (TVM) is the idea that cash, because of its potential income capability, now…
Q: Find the present value of the following annuities. Assume the discounting occurs once a year A. The…
A: The present value is calculated by multiplying the annual cash flows with the present value annuity…
Q: 0 to restore in 2018. T
A: Adjustment Journal Entry Adjustment journal entry which are provided by the business entity which…
Q: Use AstroTurf Company's income statement below to answer the following questions. Operating costs…
A: Stepwise explanation: To calculate EBITDA, add back Tax, Interest & Depreciation &…
Q: 2. The owner of Perabut Alaf Baru bought a living room set at RM2800. The operating expenses of…
A: Particulars Amount (RM) Cost of…
Q: A manufacturing firm purchased a heavy duty drilling machine. They were given two payment options:…
A: As per the given information: A= Future value = $23,550 r = rate of interest = 4.12% compounded…
Q: A-A used piece of rental equipment has 1 1/2 years of useful life remaining. When rented, the…
A: Time Value of money is the change in the value of money due to the increase in the value of money…
Q: A company has agreed to pay $4.8 million in 7 years to settle a lawsuit. How much must it invest in…
A: The amount of investment today will be the present value of the future liability at a specific…
Q: Q2. The customer and the bank buy a house for £10 million, the bank contributing 80% of the price,…
A: The rental value of a property is the fair market value of the property when it is leased out under…
Q: Jones purchased a cottage, paying $30 000 down and agreeing to pay $1800 at the end of every month…
A: The nominal interest rate is a rate mutually agreed upon between two or more parties to the…
Q: Do not use excel to answer, i need good explanation. Gurleen buys a house and takes out a mortgage…
A: A mortgage is a loan that can obtain against collateral security. Collateral security can be a…
Q: If money's worth is 7% today and you are looking for a property worth P1M. How much is the discount…
A: Money is worth 7% today and the property's price after 8 months is P 975000. Property worth today =…
Step by step
Solved in 3 steps
- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASProblem 1:Domingo Medina wants to know the amount of the quarterly rent, for which he would have to exchange a total lump sum payment of $750,000.00, with the condition that it be paid to him or his heirs for 12 years. If the finance company operates at 8¼% interest, find the value of the quarterly rent. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.On May 11, 2018, your calendar year firm pays $6,000 for a computer server, its only asset purchase for the year, and estimates that the server will have a salvage value of $500. If no Sec. 179 deduction is taken and you elect out of 100% bonus, what is your firm’s maximum 2018 deduction for depreciation? $2,000 $1,200 $1,100 $869PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASProblem 2:René Lara has just signed in notary #8, the contract for the purchase and sale of a house, for a value of 1'470,000.00. He showed the seller the equivalent of a 20% down payment, and the notary the deed expenses, valued at $25,000.00 and will pay the rest in equal monthly payments during the next 15 years, which include interest at 9½% nominal interest. a) Find the value of each of the monthly payments.b) Find the total amount paid.c) Find the total amount of interest paid.d) Find the effective rate. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel.
- Ken derived the following in the year 2021:(i) Rental surplus of $5,000 from Property 1.(ii) Rental deficit of ($6,000) from Property 2.(iii) Interest income of $12,000 from maturity of fixed deposit placement with DBS Bank, an approved bank in Singapore.(iv) Commission of $10,000 from brokering a property rental arrangement.What is Ken’s taxable income for Year of Assessment 2022? Group of answer choices a) $9,000. b) $10,000. c) $21,000. d) $27,000.On April 1, 2021 Summer Time Pools agreed to install a pool for the Stafford family. Due to the popularity of pools Summer Time and the Stafford family agreed that the pool will not be installed until May 1, 2022. The Stafford family paid Summer Time $40,000 on April 5, 202. Interest on similar project is $2,400. Will the interest be incorporated into the transaction price (yes/no) If the interest is incorporated into the price will the company recognize interest expense or interest income? What is the transaction price?On 05.20X1 the company leased the third property and received a total rent of 12 months amounting to 2400 euros. Upon payment, the amount was recognized in its entirety as revenue. On 01.08.20X1 the company bought goods with a purchase value of 12,000, for which it had given a deposit of 2,000. With the purchase, he paid 6,000 and the rest he owes. On 01.09.20X1 the company received an interest-bearing loan of 12000 euros with a duration of 8 months. The interest rate was agreed at 8% per annum and all interest will be paid at the end of the loan, together with the capital. On 01.12.20X1 the company agreed with a customer to refund the amount of 10,000 euros for cancellation of sale, due to the fact that the sold was of inferior quality. The amount will be paid on 31.05.20X2. On 112.20X1, the company signed an irrevocable (cannot be canceled) contract for the purchase of raw materials, the receipt of which will take place in February 20X2. On 31.12.20X1 the supplier's workshop…
- 2. Jason Bradley decided to buy a home for $271,000. His bank requires a 25% down payment. His attorney, has notified Jason that besides the 25% down payment there will be the following additional costs: Recording of the deed $266.00 A credit and appraisal report 1521.00 Preparation of appropriate documents 444.00 In addition, there will be a transfer tax of 1.5% of the purchase price and a loan origination fee of 3% of the mortgage amount. Assume a 30-year mortgage at a rate of 9.5%. a. What is the initial amount of cash Jason will need? (Do not round intermediate calculations. Round your answer to the nearest cent.) b. What is his monthly payment? c. What is the total cost of interest over the life of the mortgage? (Use the amortization worksheet in the financial calculator.Mr. X provided the following data on sale of his personal property sold in 2020 held by him for 15 months: Cost P225,000 Mortgage assumed by the seller 270,000 Installment Collection Schedule: 2020 67,500 2021 67,500 2022 45,000 How much is the contract price? Group of answer choices P180,000 P450,000 P225,000 P270,000Sugar has entered into a long-term contract to build an asset for a customer, Hewer. Sugar will satisfy the performance obligation over time and has measured the progress towards satisfying the performance obligation at 45% at the year end. The price of the contract is $8 million. Sugar has spent $4.5 million to date, but the estimated costs to complete are $5.5 million. To date, Hewer has paid Sugar $3 million. What is the net liability that should be recorded in Sugar’s statement of financial position?
- 1. Rey was able to sell a car whose total contract price is Php810,000. He paid Php10,000 as reservervation fee and a down payment of 20% from the unit price which is to be deducted from the total contract price. The balance will be paid through a car loan from a bank.A. How much was the gross balance or the amount to be financed by the bank? B. How much is the current increased balance if the bank charges an interest rate of 12.5%? 2. Camba family was able to buy a house and lot worth Php4,250,000 which would be financed through Pag-ibig. Their agent gave them a discount of Php100,000. The required down payment was 25% of the net price.A. How much was the down payment paid by the buyer?B. How much was the gross balance or the amount to be financed through Pag-ibig?C. How much is the current increased balance if it charges an interest rate of 27%?1. anim bought a flat for RM56,000, and get financing for 90% of the value, at 3.55% p.a., and the tenure is 7 years. How much is the annual installment? 8258.03 2. Upload amortization schedule for Anim's financing using Excel worksheet. need answer in excelPlease answer only question B, because I sent already A in a separate question. Thank you! a) The following payments are agreed for the purchase of a property at the nominal annual interest rate of 0.8%:- 100,000 euros on 01.01.2022- 50,000 Euro on 01.07.2022- 200,000 euros on 01.03.2023 What is the value of these payments on the valuation date 01.01.2022 with1. linear interest calculation?2. monthly interest at the relative interest rate?3. relative mixed interest?4. continuous interest calculation? b) On 01.01.2022, EUR 347,942.42 is paid into an account at 0.8% annual interest. At On which date (day.month.year) in 2022, the year 2022 has 365 days, will the value of the interest rate, does the value of the deposit exceed 350,000 euros for the first time?