Today is 1 January 2024. Ella used $200,000 to purchase a florist business in Sydney. To...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Today is 1 January 2024. Ella used $200,000 to purchase a florist business in Sydney. To operate this business, Ella needs to pay rent, maintenance costs, and labor costs. Here are the details: Rent will be paid by the end of each month with an amount of $2,000. Labor cost will be paid by the end of each month with an amount of $10,000. Maintenance cost will be paid by the end of each quarter with an amount of $500. Ella predicts that this florist franchise initially can have monthly revenue of $13,000. Assume that Ella can obtain this amount by the end of each month. Ella forecasts that this revenue amount will increase at the rate of y% p.a. The revenue increase will only happen at the beginning of each year. For example, this florist franchise initially has monthly revenue of $13,000 in 2024. Then the revenue amount will become $13,000(1+%) per month in 2025 and $13,000(1+%) per month in 2026. Ella plans to run this business for three years and predicts that she can sell this business on 1 January 2027 with an amount of $210,000. a. Calculate the monthly net cash flows. Assume that Ella can reinvest all profit at a rate of 4.5% p.a. Use Goal Seek to find revenue increasing rate y% p.a. if Ella requires a holding period yield rate of 7.5% p.a. for this investment (from 1 January 2024 to 1 January 2027). Label this sheet as "Part a". Today is 1 January 2024. Ella used $200,000 to purchase a florist business in Sydney. To operate this business, Ella needs to pay rent, maintenance costs, and labor costs. Here are the details: Rent will be paid by the end of each month with an amount of $2,000. Labor cost will be paid by the end of each month with an amount of $10,000. Maintenance cost will be paid by the end of each quarter with an amount of $500. Ella predicts that this florist franchise initially can have monthly revenue of $13,000. Assume that Ella can obtain this amount by the end of each month. Ella forecasts that this revenue amount will increase at the rate of y% p.a. The revenue increase will only happen at the beginning of each year. For example, this florist franchise initially has monthly revenue of $13,000 in 2024. Then the revenue amount will become $13,000(1+%) per month in 2025 and $13,000(1+%) per month in 2026. Ella plans to run this business for three years and predicts that she can sell this business on 1 January 2027 with an amount of $210,000. a. Calculate the monthly net cash flows. Assume that Ella can reinvest all profit at a rate of 4.5% p.a. Use Goal Seek to find revenue increasing rate y% p.a. if Ella requires a holding period yield rate of 7.5% p.a. for this investment (from 1 January 2024 to 1 January 2027). Label this sheet as "Part a".
Expert Answer:
Answer rating: 100% (QA)
Answer Year Monthly Revenue Total Expenses Net Cash Flow 2024 13000 1216667 83433 2025 130001y 12166... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Please solve this using Excel Functions required for each question . Part a and Part b : you can treat the implied rate as the real borrowing cost. You should include the annual fees as cash outflow...
-
Today is 1 January 2021. Jake used $200,000 to purchase a cafe business in Sydney. To operate this business, Jake needs to pay rent, maintenance costs and labour costs. Here are the details Rent...
-
A firm only uses one input in its production function, labor (L = number of workers) to produce car rides (all the workers provide their own cars, gas, etc.). The firm's total revenue (TR) function...
-
The National Automobile Dealers Association (NADA) publishes AutoExec magazine, which annually reports on new vehicle sales and market shares by manufacturer. As given on the AutoExec magazine...
-
6. Suppose you are given the following interface as: interface Animal{ String sound(); |} Implement the above interface with anonymous inner class with at least 3 separate animal objects. Also print...
-
A square aluminum plate \(5 \mathrm{~mm}\) thick and \(150 \mathrm{~mm}\) on a side is heated while vertically suspended in quiescent air at \(75^{\circ} \mathrm{C}\). Determine the average heat...
-
Use an Internet browser to search for the following terms: Electronic data interchange (EDI). Image-processing systems. Prepare a memo describing EDI and image- processing systems. Discuss the...
-
Explain the answer to this in detail for me Sala, a regular flier with Mungulu Airlines and enjoyed a 15% discount on the air fares. On each occasion he travelled from Mfuwe to Lusaka and back, he...
-
Many companies invest in training aimed at improving their business performance. An effective method of training delivery is e-learning. After visiting inspired E-learning, Write a paper in which you...
-
Due to entity incurring shipping costs as a result of importing machinery, there is a risk that the shipping costs have not been correctly capitalized to the cost of the machinery thereby affecting...
-
what should I reply back to my peer question to add to the conversation? The differences is in profit anlysis is the changes that may occur when a provider operates with in a capital environment...
-
Instructions: Choose one of the following prompts and provide an answer that includes any necessary graphs. Be sure to label everything and use the four steps Instructions for narrative: Think of...
-
The purpose of this SLO check is to demonstrate an understanding of the use of audit risk model including audit risk, inherent risk, control risk, and detection risk. You can re-do the assignment...
-
This week we are being introduced to the main concept of accounting. To start the discussion, please select from one of the following questions. I will add more questions throughout the week. 1- Why...
-
Discuss the Free Speech part of the First Amendment and what types of speeches may be limited or silenced.
-
Continuation of Exercise 4-83. (a) What is the probability that the first major crack occurs between 12 and 15 miles of the start of inspection? (b) What is the probability that there are no major...
-
Show the details leading to the equation (1.52) in the text, \[D_{\mathrm{AA}}=\frac{1}{3} \bar{c} \lambda\] where \(D_{\mathrm{AA}}\) is the self-diffusion coefficient.
-
Estimate the thermal conductivity of water if the speed of sound in water is \(1498 \mathrm{~m} / \mathrm{s}\). Compare your answer with the experimental values.
-
For most liquids other than water and substances with polyhydroxy groups, the thermal conductivity decreases with an increase in temperature. Water shows an anomalous effect. The conductivity, \(k\),...
Study smarter with the SolutionInn App